You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Jongyoul Lee <jo...@gmail.com> on 2017/05/09 17:33:50 UTC
Re: Hive Reserve Keyword support
If it's possible for you to pass that properties when you create a
connection, you can passes it by setting it into interpreter setting
On Sat, Apr 29, 2017 at 4:25 PM, Dibyendu Bhattacharya <
dibyendu.bhattachary@gmail.com> wrote:
> Hi,
>
> I have a Hive Table which has a column named date. When I tried to query
> using Zeppelin %jdbc interpreter , I got bellow error.
>
>
> Error while compiling statement: FAILED: ParseException line 1:312 Failed
> to recognize predicate 'date'. Failed rule: 'identifier' in expression
> specification
> class org.apache.hive.service.cli.HiveSQLException
> org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
> org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)
> org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254)
> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
> JDBCInterpreter.java:322)
> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
> JDBCInterpreter.java:408)
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
> LazyOpenInterpreter.java:94)
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
> InterpretJob.jobRun(RemoteInterpreterServer.java:341)
> org.apache.zeppelin.scheduler.Job.run(Job.java:176)
> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.
> run(ParallelScheduler.java:162)
>
>
> My query looks like this :
>
> select x,y,z from mytable where date = '2017-04-28"
>
> I believe it is failing because date is reserve keyword . Is there anyway
> I can set hive.support.sql11.reserved.keywords=false in Zeppelin ?
>
> regards,
> Dibyendu
>
>
>
>
--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net
Re: Hive Reserve Keyword support
Posted by Dibyendu Bhattacharya <di...@gmail.com>.
right. This backticks worked
On Wed, May 10, 2017 at 8:51 AM, Felix Cheung <fe...@hotmail.com>
wrote:
> I think you can put backticks around the name date
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
>
> ------------------------------
> *From:* Jongyoul Lee <jo...@gmail.com>
> *Sent:* Tuesday, May 9, 2017 10:33:50 AM
> *To:* users@zeppelin.apache.org
> *Subject:* Re: Hive Reserve Keyword support
>
> If it's possible for you to pass that properties when you create a
> connection, you can passes it by setting it into interpreter setting
>
> On Sat, Apr 29, 2017 at 4:25 PM, Dibyendu Bhattacharya <
> dibyendu.bhattachary@gmail.com> wrote:
>
>> Hi,
>>
>> I have a Hive Table which has a column named date. When I tried to query
>> using Zeppelin %jdbc interpreter , I got bellow error.
>>
>>
>> Error while compiling statement: FAILED: ParseException line 1:312 Failed
>> to recognize predicate 'date'. Failed rule: 'identifier' in expression
>> specification
>> class org.apache.hive.service.cli.HiveSQLException
>> org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
>> org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)
>> org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254)
>> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInte
>> rpreter.java:322)
>> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInter
>> preter.java:408)
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.
>> interpret(LazyOpenInterpreter.java:94)
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServ
>> er$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
>> org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.ru
>> n(ParallelScheduler.java:162)
>>
>>
>> My query looks like this :
>>
>> select x,y,z from mytable where date = '2017-04-28"
>>
>> I believe it is failing because date is reserve keyword . Is there anyway
>> I can set hive.support.sql11.reserved.keywords=false in Zeppelin ?
>>
>> regards,
>> Dibyendu
>>
>>
>>
>>
>
>
> --
> 이종열, Jongyoul Lee, 李宗烈
> http://madeng.net
>
Re: Hive Reserve Keyword support
Posted by Felix Cheung <fe...@hotmail.com>.
I think you can put backticks around the name date
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL
________________________________
From: Jongyoul Lee <jo...@gmail.com>
Sent: Tuesday, May 9, 2017 10:33:50 AM
To: users@zeppelin.apache.org
Subject: Re: Hive Reserve Keyword support
If it's possible for you to pass that properties when you create a connection, you can passes it by setting it into interpreter setting
On Sat, Apr 29, 2017 at 4:25 PM, Dibyendu Bhattacharya <di...@gmail.com>> wrote:
Hi,
I have a Hive Table which has a column named date. When I tried to query using Zeppelin %jdbc interpreter , I got bellow error.
Error while compiling statement: FAILED: ParseException line 1:312 Failed to recognize predicate 'date'. Failed rule: 'identifier' in expression specification
class org.apache.hive.service.cli.HiveSQLException
org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)
org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:254)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:322)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:408)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
My query looks like this :
select x,y,z from mytable where date = '2017-04-28"
I believe it is failing because date is reserve keyword . Is there anyway I can set hive.support.sql11.reserved.keywords=false in Zeppelin ?
regards,
Dibyendu
--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net