You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jon (JIRA)" <ji...@apache.org> on 2015/10/14 12:31:05 UTC
[jira] [Updated] (DRILL-3933) Error execute select command line
sqlline -u -q
[ https://issues.apache.org/jira/browse/DRILL-3933?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jon updated DRILL-3933:
-----------------------
Description:
I'm newbie with Drill and Jira, so sorry if this is not the correct site.
When I query : "sqlline -u 'jdbc:drill:drillbit=localhost' -q 'select * from hive.database.table;' " return:
"select anaconda-ks.cfg build.out install.log install.log.syslog ranger_tutorial sandbox.info start_ambari.sh start_hbase.sh start_solr.sh stop_solr.sh from hive.database.table;"
Error: PARSE ERROR: Encountered "." at line 1, column 29.
Was expecting one of:
"FROM" ...
"," ...
So, to fix this, i should type all columns to do this one work.
But, if I used UI, in localhost:8047/query, the query works. Drill is connected to Hive with plugin of course. Is this a bug or something? Bad conf.?
was:
I'm newbie with Drill and Jira, so sorry if this is not the correct site.
When I query : "sqlline -u 'jdbc:drill:drillbit=localhost' -q 'select * from hive.database.table;' " return:
Error: PARSE ERROR: Encountered "." at line 1, column 29.
Was expecting one of:
"FROM" ...
"," ...
But, if I used UI, in localhost:8047/query, the query works. Drill is connected to Hive with plugin of course. Is this a bug or something?
> Error execute select command line sqlline -u -q
> -----------------------------------------------
>
> Key: DRILL-3933
> URL: https://issues.apache.org/jira/browse/DRILL-3933
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.1.0
> Reporter: Jon
> Labels: bug, newbie
>
> I'm newbie with Drill and Jira, so sorry if this is not the correct site.
> When I query : "sqlline -u 'jdbc:drill:drillbit=localhost' -q 'select * from hive.database.table;' " return:
> "select anaconda-ks.cfg build.out install.log install.log.syslog ranger_tutorial sandbox.info start_ambari.sh start_hbase.sh start_solr.sh stop_solr.sh from hive.database.table;"
> Error: PARSE ERROR: Encountered "." at line 1, column 29.
> Was expecting one of:
> "FROM" ...
> "," ...
> So, to fix this, i should type all columns to do this one work.
> But, if I used UI, in localhost:8047/query, the query works. Drill is connected to Hive with plugin of course. Is this a bug or something? Bad conf.?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)