Home | About | Sematext search-lucene.com search-hadoop.com
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
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> "show table" throwing strange error


+
Mohammad Tariq 2013-06-20, 00:53
+
Anurag Tangri 2013-06-20, 01:23
+
Mohammad Tariq 2013-06-20, 01:30
+
Mapred Learn 2013-06-20, 01:36
Copy link to this message
-
Re: "show table" throwing strange error
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
+
Mohammad Tariq 2013-06-20, 01:44
+
Anurag Tangri 2013-06-20, 01:51
+
Mohammad Tariq 2013-06-20, 01:59
+
Mohammad Tariq 2013-06-20, 02:04
+
Sunita Arvind 2013-06-20, 03:13
+
Mohammad Tariq 2013-06-20, 11:28
+
Sanjay Subramanian 2013-06-20, 19:33
+
Mohammad Tariq 2013-06-20, 19:52
+
Sanjay Subramanian 2013-06-21, 19:17
+
kulkarni.swarnim@...) 2013-06-21, 20:56
+
shashwat shriparv 2013-06-22, 09:58
+
Mohammad Tariq 2013-07-01, 02:43
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