We simplify object storage and DW integration. Now you can create a table from filebrowser, just select a file and click the “Open in Importer” option and also you can copy the path of a file by clicking the “Copy Path” option in fileborwser.
If you want to create a table then you can use either “Open in Importer” option or Importer directly but if you want a table from your SQL then just copy the path of a file as described above and use it in the editor.
create EXTERNAL TABLE book ( id BIGINT, isbn STRING, category STRING, publish_date TIMESTAMP, publisher STRING, price FLOAT ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile LOCATION 's3a://cldr-demo/books/books.csv';
Ayush from the Hue Team