Hello all, Apologies for being unresponsive. Was busy with some urgent deliverable.
Inspite of all your help and trying continuously for several days it didn't work. I tried almost everything, including whatever you guys had suggested. As a result I had to reconfigure Hive and now it's working perfectly fine. Still I would love to hear if someone has something to about this. Thank you so much for your precious time. Warm Regards, Tariq cloudfront.blogspot.com On Sat, Jun 22, 2013 at 3:28 PM, shashwat shriparv < dwivedishash...@gmail.com> wrote: > Create hive-site.xml paste following > > and try > > <?xml version="1.0"?> > <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> > <!-- > Licensed to the Apache Software Foundation (ASF) under one or more > contributor license agreements. See the NOTICE file distributed with > this work for additional information regarding copyright ownership. > The ASF licenses this file to You under the Apache License, Version 2.0 > (the "License"); you may not use this file except in compliance with > the License. You may obtain a copy of the License at > > http://www.apache.org/licenses/LICENSE-2.0 > > Unless required by applicable law or agreed to in writing, software > distributed under the License is distributed on an "AS IS" BASIS, > WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. > See the License for the specific language governing permissions and > limitations under the License. > --> > > > <configuration> > <property> > <name>javax.jdo.option.ConnectionURL</name> > > <value>jdbc:mysql://localhost:3306/hivemeta?createDatabaseIfNotExist=true</value> > <description>the URL of the MySQL database</description> > > </property> > > <property> > <name>javax.jdo.option.ConnectionDriverName</name> > <value>com.mysql.jdbc.Driver</value> > </property> > > <property> > <name>javax.jdo.option.ConnectionUserName</name> > <value>username</value> > > </property> > > <property> > <name>javax.jdo.option.ConnectionPassword</name> > <value>passwore</value> > </property> > </configuration> > > > > *Thanks & Regards * > > ∞ > Shashwat Shriparv > > > > On Sat, Jun 22, 2013 at 2:26 AM, kulkarni.swar...@gmail.com < > kulkarni.swar...@gmail.com> wrote: > >> More often than not in my experience is caused by a malformed >> hive-site.xml(or hive-default.xml). When this happened to me, it was >> because I somehow had tab characters in my hive-site.xml. Try dropping the >> file(s) and recreate with appropriate formatting. >> >> >> On Fri, Jun 21, 2013 at 2:17 PM, Sanjay Subramanian < >> sanjay.subraman...@wizecommerce.com> wrote: >> >>> Can u stop following services >>> hive-server >>> hive-meta-store >>> Hive-server2 (if u r running that) >>> >>> Move current hive.log some place else >>> >>> Start following services >>> hive-server >>> hive-meta-store >>> Hive-server2 (if u r running that) >>> >>> >>> And check hive.log ? >>> >>> Also can u paste the CREATE TABLe script verbatim here…I feel if u are >>> using some custom INPUTFORMAT / OUTPUTFORMAT class that have to be >>> specified in quotes…u may have to be *escape* that >>> >>> Plus try and add a semicolon to the end of the create table script ... >>> >>> sanjay >>> >>> From: Mohammad Tariq <donta...@gmail.com> >>> Reply-To: "user@hive.apache.org" <user@hive.apache.org> >>> Date: Thursday, June 20, 2013 12:52 PM >>> >>> To: user <user@hive.apache.org> >>> Subject: Re: "show table" throwing strange error >>> >>> Thank you for looking into it Sanjay. "show tables" is working fine >>> from both Ubuntu and Hive shell. But i'm getting the same error as >>> yesterday when i'm running "create table", which is : >>> >>> 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 >>> . >>> . >>> . >>> . >>> >>> Also, I have noticed 1 strange thing. "hive.log" is totally messed up. >>> Looks like logs are getting written in some binary encoding. I have >>> attached a snapshot of the same. Any idea? >>> >>> Warm Regards, >>> Tariq >>> cloudfront.blogspot.com >>> >>> >>> On Fri, Jun 21, 2013 at 1:03 AM, Sanjay Subramanian < >>> sanjay.subraman...@wizecommerce.com> wrote: >>> >>>> Can u try from your ubuntu command prompt >>>> $> hive -e "show tables" >>>> >>>> From: Mohammad Tariq <donta...@gmail.com> >>>> Reply-To: "user@hive.apache.org" <user@hive.apache.org> >>>> Date: Thursday, June 20, 2013 4:28 AM >>>> To: user <user@hive.apache.org> >>>> >>>> Subject: Re: "show table" throwing strange error >>>> >>>> Thank you for the response ma'am. It didn't help either. >>>> >>>> Warm Regards, >>>> Tariq >>>> cloudfront.blogspot.com >>>> >>>> >>>> On Thu, Jun 20, 2013 at 8:43 AM, Sunita Arvind >>>> <sunitarv...@gmail.com>wrote: >>>> >>>>> Your issue seems familiar. Try logging out of hive session and >>>>> re-login. >>>>> >>>>> Sunita >>>>> >>>>> >>>>> On Wed, Jun 19, 2013 at 8: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 >>>>>> >>>>> >>>>> >>>> >>>> CONFIDENTIALITY NOTICE >>>> ====================== >>>> This email message and any attachments are for the exclusive use of the >>>> intended recipient(s) and may contain confidential and privileged >>>> information. Any unauthorized review, use, disclosure or distribution is >>>> prohibited. If you are not the intended recipient, please contact the >>>> sender by reply email and destroy all copies of the original message along >>>> with any attachments, from your computer system. If you are the intended >>>> recipient, please be advised that the content of this message is subject to >>>> access, review and disclosure by the sender's Email System Administrator. >>>> >>> >>> >>> CONFIDENTIALITY NOTICE >>> ====================== >>> This email message and any attachments are for the exclusive use of the >>> intended recipient(s) and may contain confidential and privileged >>> information. Any unauthorized review, use, disclosure or distribution is >>> prohibited. If you are not the intended recipient, please contact the >>> sender by reply email and destroy all copies of the original message along >>> with any attachments, from your computer system. If you are the intended >>> recipient, please be advised that the content of this message is subject to >>> access, review and disclosure by the sender's Email System Administrator. >>> >> >> >> >> -- >> Swarnim >> > >