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.
