Awesome!!
Works like charm. Thanks!! :)
________________________________________
From: Mehant Baid [[email protected]]
Sent: Saturday, March 08, 2014 10:32 PM
To: [email protected]
Subject: Re: Error while starting Sqlline on latest master
Try using backquote (`) instead of the single quote (') for the table
name like the following
select employee_id, first_name from cp.`employee.json`;
Thanks
Mehant
On 3/8/14, 8:42 AM, Yash Sharma wrote:
> 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.
________________________________
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.
