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
