Re: "show table" throwing strange error

[Mohammad Tariq <do...@gmail.com>]

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 <
dwivedishashwat@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.swarnim@gmail.com <
> kulkarni.swarnim@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.Subramanian@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 <do...@gmail.com>
>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>> Date: Thursday, June 20, 2013 12:52 PM
>>>
>>> To: user <us...@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.Subramanian@wizecommerce.com> wrote:
>>>
>>>>  Can u try from your ubuntu command prompt
>>>> $> hive -e "show tables"
>>>>
>>>>   From: Mohammad Tariq <do...@gmail.com>
>>>> Reply-To: "user@hive.apache.org" <us...@hive.apache.org>
>>>> Date: Thursday, June 20, 2013 4:28 AM
>>>> To: user <us...@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 <su...@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 <do...@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
>>
>
>