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
namejavax.jdo.option.ConnectionURL/name
valuejdbc:mysql://localhost:3306/hivemeta?createDatabaseIfNotExist=true/value
descriptionthe URL of the MySQL database/description
/property
property
namejavax.jdo.option.ConnectionDriverName/name
valuecom.mysql.jdbc.Driver/value
/property
property
namejavax.jdo.option.ConnectionUserName/name
valueusername/value
/property
property
namejavax.jdo.option.ConnectionPassword/name
valuepasswore/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.comwrote:
Your issue seems familiar. Try logging out of hive session and
re-login.
Sunita
On Wed, Jun 19, 2013 at 8:53 PM, Mohammad