Hii all, I have deployed Apache Pinot on AKS cluster. I am unable to use Query console for batch ingest from ADLS.

Can you provide more info? Does the query return empty results, or does it fail? What do you see for the table?

I have created offline tables using Query Console. But when I am trying to ingest data into table it gives parsing errors and also facing issues related setting OPTION for ingestion.

Can you paste the error

INSERT INTO 'demo' FROM FILE 'my file address ' OPTION(taskName=myTask-adls) OPTION(input.fs.className=org.apache.pinot.plugin.filesystem.ADLSGen2PinotFS) OPTION(input.fs.prop.accountName='pinotstorage') OPTION(input.fs.prop.accountKey='my-key') OPTION(input.fs.prop.region='East Asia') This I ran and following error I got: SQLParsingError: org.apache.pinot.sql.parsers.SqlCompilationException: Caught exception while parsing query: INSERT INTO 'demo' FROM FILE '---------' OPTION(taskName='myTask-adls') OPTION(input.fs.className='org.apache.pinot.plugin.filesystem.ADLSGen2PinotFS') OPTION(input.fs.prop.accountName='pinotstorage') OPTION(input.fs.prop.accountKey='') ... Caused by: org.apache.pinot.sql.parsers.parser.ParseException: Encountered "" at line 1, column 13. at org.apache.pinot.sql.parsers.parser.SqlParserImpl.generateParseException(SqlParserImpl.java:38633) at org.apache.pinot.sql.parsers.parser.SqlParserImpl.jj_consume_token(SqlParserImpl.java:38430) at org.apache.pinot.sql.parsers.parser.SqlParserImpl.IdentifierSegment(SqlParserImpl.java:5272) at org.apache.pinot.sql.parsers.parser.SqlParserImpl.SimpleIdentifier(SqlParserImpl.java:5323)