Importer option in hue is not working with s3 file

We are using mariadb as metastore db and we have hive-metastore-standalone service and using hue 4.7.1 version , when using the importer option and select file from s3 with csv format we are getting below error message once we click on submit

(_mysql_exceptions.ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXTERNAL TABLE default.dummy\n(\n applestring ,\nbananastring ) ROW...' at line 1") [SQL: CREATE EXTERNAL TABLEdefault.dummy(applestring ,banana string ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TextFile LOCATION 's3a://testbucket/Test/dummy.csv16849b59-73e3-45f7-9034-92cd8a7eef7c_table' TBLPROPERTIES("skip.header.line.count" = "1", "transactional" = "false") ;] (Background on this error at:

So the importer option is generating hive query but we are using mariadb as database so is there any configuration from hue to generate mysql query instead of hive query for importing option or can you suggest the appropriate solution for the above issue

@bjorn_alm @ayush.goyal Any thoughts on the above scenario ?

Hi @Ramesh,
As of today, Hue importer only generates the Hive and Impala query. You will not be able to create the table via remote file option in mariadb. Although you can try the local file option in importer (if the file presents in the local system).