[flink-1.9] how to read local json file through Flink SQL

Posted by Anyang Hu on
URL: http://deprecated-apache-flink-user-mailing-list-archive.369.s1.nabble.com/flink-1-9-how-to-read-local-json-file-through-Flink-SQL-tp29876.html

Hi guys,

In flink1.9, is there a way to read local json file in Flink SQL like the reading of csv file?

Now we can read local csv file like the following, replacing of  'csv' to 'json' can not work:

create table source (
first varchar,
id int
) with (
'connector.type' = 'filesystem',
'connector.path' = '/path/to/csv',
'format.type' = 'csv'
)

Best regards,

Anyang