Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - "show table" throwing strange error


Copy link to this message
-
Re: "show table" throwing strange error
Mohammad Tariq 2013-06-20, 01:42
It looks OK to me,

<configuration>

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost:3306/hive?*createDatabaseIfNotExist*=true
</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>apache</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>password</value>
</property>

<property>
  <name>hive.metastore.local</name>
  <value>true</value>
</property>

<property>
    <name>hive.exec.scratchdir</name>
    <value>/hadoop/hive-tmp</value>
    <description>Scratch space for Hive jobs</description>
</property>

</configuration>

Anything wrong here?

Thank you.

Warm Regards,
Tariq
cloudfront.blogspot.com
On Thu, Jun 20, 2013 at 7:06 AM, Mapred Learn <[EMAIL PROTECTED]>wrote:

> Can you also check your hive site XML ?
> Is it properly formatted and connection strings correct ?
>
> Sent from my iPhone
>
> On Jun 19, 2013, at 6:30 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:
>
> Hello Anurag,
>
>    Thank you for the quick response. Log files is full of such lines along
> with a trace that says it is some parsing related issue. But the strange
> thing is that here I can see *'\00' *but on the CLI it was just *' '. *I
> am wondering what's with wrong with *show tables;*
> *
> *
> line 1:79 character '\00' not supported here
> line 1:80 character '\00' not supported here
>
> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:446)
>  at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:416)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336)
>  at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)
> at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)
>  at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)
>  at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:689)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:557)
>  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>  at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
>  at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
>
> Thanks again.
>
> Warm Regards,
> Tariq
> cloudfront.blogspot.com
>
>
> On Thu, Jun 20, 2013 at 6:53 AM, Anurag Tangri <[EMAIL PROTECTED]>wrote:
>
>> Did you check in your hive query log under /tmp to see if it says
>> something in the log ?
>>
>>
>> Sent from my iPhone
>>
>> On Jun 19, 2013, at 5:53 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:
>>
>> Hello list,
>>
>>          I have a hive(0.9.0) setup on my Ubuntu box running
>> hadoop-1.0.4. Everything was going smooth till now. But today when I issued
>> *show tables* I got some strange error on the CLI. Here is the error :
>>
>> hive> show tables;
>> FAILED: Parse Error: line 1:0 character '' not supported here
>> line 1:1 character '' not supported here
>> line 1:2 character '' not supported here
>> line 1:3 character '' not supported here
>> line 1:4 character '' not supported here
>> line 1:5 character '' not supported here
>> line 1:6 character '' not supported here
>> line 1:7 character '' not supported here
>> line 1:8 character '' not supported here
>> line 1:9 character '' not supported here
>> line 1:10 character '' not supported here
>> line 1:11 character '' not supported here
>> line 1:12 character '' not supported here
>> line 1:13 character '' not supported here
>> line 1:14 character '' not supported here
>> line 1:15 character '' not supported here
>> line 1:16 character '' not supported here
>> line 1:17 character '' not supported here
>> line 1:18 character '' not supported here
>> line 1:19 character '' not supported here