Looks like you use MySQL. Can you check if your MySQL still up ?
and permissions on your hive metastore db ? Sent from my iPhone On Jun 19, 2013, at 6:44 PM, Mohammad Tariq <donta...@gmail.com> wrote: > It actually seems to be ignoring hive-site.xml. No effect of the properties > set in hive-site.xml file. > > Warm Regards, > Tariq > cloudfront.blogspot.com > > > On Thu, Jun 20, 2013 at 7:12 AM, Mohammad Tariq <donta...@gmail.com> wrote: >> 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 <mapred.le...@gmail.com> 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 <donta...@gmail.com> 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 <tangri.anu...@gmail.com> >>>> 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 <donta...@gmail.com> 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 >>>>>> line 1:20 character '' not supported here >>>>>> line 1:21 character '' not supported here >>>>>> line 1:22 character '' not supported here >>>>>> line 1:23 character '' not supported here >>>>>> line 1:24 character '' not supported here >>>>>> line 1:25 character '' not supported here >>>>>> line 1:26 character '' not supported here >>>>>> line 1:27 character '' not supported here >>>>>> line 1:28 character '' not supported here >>>>>> line 1:29 character '' not supported here >>>>>> line 1:30 character '' not supported here >>>>>> line 1:31 character '' not supported here >>>>>> line 1:32 character '' not supported here >>>>>> line 1:33 character '' not supported here >>>>>> line 1:34 character '' not supported here >>>>>> line 1:35 character '' not supported here >>>>>> line 1:36 character '' not supported here >>>>>> line 1:37 character '' not supported here >>>>>> line 1:38 character '' not supported here >>>>>> line 1:39 character '' not supported here >>>>>> line 1:40 character '' not supported here >>>>>> line 1:41 character '' not supported here >>>>>> line 1:42 character '' not supported here >>>>>> line 1:43 character '' not supported here >>>>>> line 1:44 character '' not supported here >>>>>> line 1:45 character '' not supported here >>>>>> line 1:46 character '' not supported here >>>>>> line 1:47 character '' not supported here >>>>>> line 1:48 character '' not supported here >>>>>> line 1:49 character '' not supported here >>>>>> line 1:50 character '' not supported here >>>>>> line 1:51 character '' not supported here >>>>>> line 1:52 character '' not supported here >>>>>> line 1:53 character '' not supported here >>>>>> line 1:54 character '' not supported here >>>>>> line 1:55 character '' not supported here >>>>>> line 1:56 character '' not supported here >>>>>> line 1:57 character '' not supported here >>>>>> line 1:58 character '' not supported here >>>>>> line 1:59 character '' not supported here >>>>>> line 1:60 character '' not supported here >>>>>> line 1:61 character '' not supported here >>>>>> line 1:62 character '' not supported here >>>>>> line 1:63 character '' not supported here >>>>>> line 1:64 character '' not supported here >>>>>> line 1:65 character '' not supported here >>>>>> line 1:66 character '' not supported here >>>>>> line 1:67 character '' not supported here >>>>>> line 1:68 character '' not supported here >>>>>> line 1:69 character '' not supported here >>>>>> line 1:70 character '' not supported here >>>>>> line 1:71 character '' not supported here >>>>>> line 1:72 character '' not supported here >>>>>> line 1:73 character '' not supported here >>>>>> line 1:74 character '' not supported here >>>>>> line 1:75 character '' not supported here >>>>>> line 1:76 character '' not supported here >>>>>> line 1:77 character '' not supported here >>>>>> line 1:78 character '' not supported here >>>>>> line 1:79 character '' not supported here >>>>>> . >>>>>> . >>>>>> . >>>>>> . >>>>>> . >>>>>> . >>>>>> line 1:378 character '' not supported here >>>>>> line 1:379 character '' not supported here >>>>>> line 1:380 character '' not supported here >>>>>> line 1:381 character '' not supported here >>>>>> >>>>>> Strangely other queries like select foo from pokes where bar = 'tariq'; >>>>>> are working fine. Tried to search over the net but could not find >>>>>> anything useful.Need some help. >>>>>> >>>>>> Thank you so much for your time. >>>>>> >>>>>> Warm Regards, >>>>>> Tariq >>>>>> cloudfront.blogspot.com >
