Hi Divya, the reason Drill does not see .txt file is that it is not defined in storage plugin (dfs) formats. You can add new format to the storage plugin using Web UI or use table function [1].
[1] https://drill.apache.org/docs/plugin-configuration-basics/ Kind regards Arina On Fri, Jul 21, 2017 at 7:32 AM, Divya Gehlot <[email protected]> wrote: > Hi, > I am unbale to *.txt* file on drill on windows embedded mode . > > Getting following error : > > > 0: jdbc:drill:zk=local> SELECT * FROM > > dfs.`installedsoftwares/ApacheDrill/apache-drill-1.10. > 0.tar/apache-drill-1.10.0/sample-data/2017-02-020024.txt`; > > Jul 21, 2017 12:16:54 PM > > org.apache.calcite.sql.validate.SqlValidatorException <init> > > SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table > > 'dfs.installedsoftwares/ApacheDrill/apache-drill-1.10. > 0.tar/apache-drill-1.10.0/sample-data/2017-02-020024.txt' > > not found > > Jul 21, 2017 12:16:54 PM org.apache.calcite.runtime.CalciteException > <init> > > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, > > column 15 to line 1, column 17: Table > > 'dfs.installedsoftwares/ApacheDrill/apache-drill-1.10. > 0.tar/apache-drill-1.10.0/sample-data/2017-02-020024.txt' > > not found > > Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: > > Table > > 'dfs.installedsoftwares/ApacheDrill/apache-drill-1.10. > 0.tar/apache-drill-1.10.0/sample-data/2017-02-020024.txt' > > not found > > > > But same file if I save it as .csv extension I am able to read it . > > Appreciate the help. > > > Thanks, > Divya > > > SQL Query null >
