title: How can we define nested json properties (including arrays) using Flink SQL API?
body: <p>We have the following problem while using Flink SQL: we have configured Kafka Twitter connector to add tweets to Kafka and we want to read the tweets from Kafka in a table using Flink SQL.</p>
  <p>How can we define nested json properties (including arrays) using Flink SQL API ?</p>
  <p>We have tried the following, but it does not work (the values returned are empty):</p>
  <pre><code>CREATE TABLE kafka_tweets(
    payload ROW(`HashtagEntities` ARRAY[VARCHAR])
  ) WITH (
    'connector' = 'kafka',
    'topic' = 'twitter_status',
    'properties.bootstrap.servers' = 'localhost:9092',
    'properties.group.id' = 'testGroup',
    'scan.startup.mode' = 'earliest-offset',
    'format' = 'json'
  )
  </code></pre>
  <p>In the twitter response HashtagEntities is an array of objects.</p>