Drill, mail # dev - Error while starting Sqlline on latest master - 2014-03-08, 16:42
 Search Hadoop and all its subprojects:

Switch to Plain View
Copy link to this message
-
Error while starting Sqlline on latest master
Hi All,
I was trying to run queries on Sqlline and am stumbling at this error.
I am on the latest master and have followed the installation notes on github (https://github.com/apache/incubator-drill/blob/master/INSTALL.md).

Am I missing something?

Regards,
Yash
0: jdbc:drill:zk=local> SELECT employee_id, first_name FROM cp.'employee.json';
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "836beda1-e069-4efc-af67-82f5f0eb9e4a"
endpoint {
  address: "black-box"
  user_port: 31010
  control_port: 31011
  data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered \". \\\'employee.json\\\'\" at line 1, column 39.\nWas expecting one of:\n    <EOF> \n    \"ORDER\" ...\n    \"LIMIT\" ...\n    \"OFFSET\" ...\n    \"FETCH\" ...\n    \"NATURAL\" ...\n    \"JOIN\" ...\n    \"INNER\" ...\n    \"LEFT\" ...\n    \"RIGHT\" ...\n    \"FULL\" ...\n    \"CROSS\" ...\n    \",\" ...\n    \".\" ...\n    \"AS\" ...\n    <IDENTIFIER> ...\n    <QUOTED_IDENTIFIER> ...\n    <BACK_QUOTED_IDENTIFIER> ...\n    <BRACKET_QUOTED_IDENTIFIER> ...\n    <UNICODE_QUOTED_IDENTIFIER> ...\n    \"TABLESAMPLE\" ...\n    \"WHERE\" ...\n    \"GROUP\" ...\n    \"HAVING\" ...\n    \"WINDOW\" ...\n    \"UNION\" ...\n    \"INTERSECT\" ...\n    \"EXCEPT\" ...\n    \".\" <IDENTIFIER> ...\n    \".\" <QUOTED_IDENTIFIER> ...\n    \".\" <BACK_QUOTED_IDENTIFIER> ...\n    \".\" <BRACKET_QUOTED_IDENTIFIER> ...\n    \".\" <UNICODE_QUOTED_IDENTIFIER> ...\n     ] < ParseException:[ Encountered \". \\\'employee.json\\\'\" at line 1, column 39.\nWas expecting one of:\n    <EOF> \n    \"ORDER\" ...\n    \"LIMIT\" ...\n    \"OFFSET\" ...\n    \"FETCH\" ...\n    \"NATURAL\" ...\n    \"JOIN\" ...\n    \"INNER\" ...\n    \"LEFT\" ...\n    \"RIGHT\" ...\n    \"FULL\" ...\n    \"CROSS\" ...\n    \",\" ...\n    \".\" ...\n    \"AS\" ...\n    <IDENTIFIER> ...\n    <QUOTED_IDENTIFIER> ...\n    <BACK_QUOTED_IDENTIFIER> ...\n    <BRACKET_QUOTED_IDENTIFIER> ...\n    <UNICODE_QUOTED_IDENTIFIER> ...\n    \"TABLESAMPLE\" ...\n    \"WHERE\" ...\n    \"GROUP\" ...\n    \"HAVING\" ...\n    \"WINDOW\" ...\n    \"UNION\" ...\n    \"INTERSECT\" ...\n    \"EXCEPT\" ...\n    \".\" <IDENTIFIER> ...\n    \".\" <QUOTED_IDENTIFIER> ...\n    \".\" <BACK_QUOTED_IDENTIFIER> ...\n    \".\" <BRACKET_QUOTED_IDENTIFIER> ...\n    \".\" <UNICODE_QUOTED_IDENTIFIER> ...\n     ]"
]
Error: exception while executing query (state=,code=0)

________________________________
NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.

 
+
Mehant Baid 2014-03-08, 17:03
+
Aman Sinha 2014-03-08, 17:37
+
Yash Sharma 2014-03-08, 17:12
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB