Hi,
I have run "analyse table" command several times to get statistics,
but I always get num_rows=0 like below.
(also, raw_data_size is 0)
-
hive> analyze table lineitem compute statistics;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no r
I gone through the thread.
http://www.mail-archive.com/user@hive.apache.org/msg01293.html
My problem resolved when I create metastore schema manually.
I have few doubts here
1. For derby , we need not to create metastore schema explicitely where as
for postgres drop table query worked when metas
Yes.. Problem(ERROR) is same.
My scenario is I am installing fresh cluster with Hive-0.9.0 +
postgres-9.0.7
I am not doing any upgrade for metastore. Still I am facing this problem.
-Original Message-
From: wd [mailto:w...@wdicc.com]
Sent: Wednesday, August 29, 2012 11:07 AM
To: use
http://www.mail-archive.com/user@hive.apache.org/msg01293.html
Maybe the same error?
On Wed, Aug 29, 2012 at 12:27 PM, rohithsharma
wrote:
> Hi
>
>
>
> I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated
> postgres with hive. Few queries are working fine. I am using
>
> postg
Hi
I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated
postgres with hive. Few queries are working fine. I am using
postgresql-9.0-802.jdbc3.jar for connecting to JDBC.
But "drop table query" is hanging. Following is Hive DEBUG log .
08/12/28 06:02:09 DEBUG lazy
Hi
I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated
postgres with hive. Few queries are working fine. I am using
postgresql-9.0-802.jdbc3.jar for connecting to JDBC.
But "drop table query" is hanging. Following is Hive DEBUG log .
08/12/28 06:02:09 DEBUG lazy
Hi Suman,
We've seen this happen due to a bug in Hive's CombineHiveInputFormat. Try
disabling that before querying by issuing:
SET hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
HTH,
Joe
On Fri, Aug 24, 2012 at 4:43 PM, wrote:
> Hi,
>
> I have setup a Hadoop cluster on A
Hi, all. I'm new to Hive, I have a question about executeUpdate.
I executed a SQL by invoking HiveStatement.executeUpdate method. I found that
it throws an "Method not supported" exception.
And I checked the code in
hive-0.9\jdbc\src\java\org\apache\hadoop\hive\jdbc\HiveStatement.java, I found
Hi Kiwon
You can get this information from the jobdetails web page itself. Browse to
your failed task and there you can see the details on which file/block it had
processed and failed with the error.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-Original Message-
From: Ra
That basically means your data was not in the correct format when you move
or copied the data to HDFS. So there is one file which is corrupted, you
can find the file name in your error logs.
*Raihan Jamal*
On Tue, Aug 28, 2012 at 7:23 AM, Kiwon Lee wrote:
> Hi
>
> I have a lot of compressed
I managed to find the _metadata file associated with my table in Hive and I
am trying to make sense of the information it contains. Besides some
straight-forward properties like table name, schema, SerDe classes, there
are some interesting ones like:
*"i32":1345739794*
*
*
*"transient_lastDdlTime"
Hi
I am using PostgreSQl-9.0.7 as metastore and + Hive-0.9.0. I integrated
postgres with hive. Few queries are working fine. I am using
postgresql-9.0-802.jdbc3.jar for connecting to JDBC.
But "drop table query" is hanging. Following is Hive DEBUG log .
08/12/28 06:02:09 DEBUG lazy
Hi,
FYI, my colleagues have found the problem. It's the asterisk in the end of the
directory - in case of an external table if should not be there.
Regards,
Zoltan
From: Zoltán Tóth-Czifra [zoltan.tothczi...@softonic.com]
Sent: Monday, August 27, 2012 6:25 PM
To:
13 matches
Mail list logo
