Re: analyze hive tables with null values in partition columns

2014-04-28 Thread Dileep Kumar
> I have a table that has partition based on column ss_sold_date_sk which > has null value partition as well. > > When I run the analyze ..compute stat it fails with attached exception. > Is there a way to avoid this or bypass this exception, also what would be > the impact on query performance of

Re: Hive query started map task being killed during execution

2013-03-08 Thread Dileep Kumar
e/metastore_db;create=true > JDBC connect string for a JDBC metastore > > > > On Fri, Mar 8, 2013 at 4:09 PM, Dileep Kumar wrote: > >> Hi All, >> >> I am running a hive query which does insert into a table. >> What I noticed from the symptom it looks li

Not able to use the timestamp columns

2013-03-05 Thread Dileep Kumar
Hi All, I am looking for some help in using timestamp column and not sure why I am getting this error: Here are how I created the tables and how I am querying it --hdfs dfs -mkdir /hive/tpcds/date_ts create external table date_ts ( d_datetimestamp ) row format delimited fi

Re: Hive insert into RCFILE issue with timestamp columns

2013-03-05 Thread Dileep Kumar
fff] Time taken: 3.556 seconds [cloudera@localhost tmp-work]$ hdfs dfs -cat /hive/tpcds/date_ts/* 2415022|OKJNECAA|1900-01-02 02:00:21.0|0|1|1|1900|1|1|2|1|1900|1|1|Monday|1900Q1|N|N|Y|2415021|2415020|2414657|2414930|N|N|N|N|N| On Mon, Mar 4, 2013 at 6:00 PM, Dileep Kumar wrote: >

Re: Hive insert into RCFILE issue with timestamp columns

2013-03-04 Thread Dileep Kumar
spector.java:188) at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.evaluate(ExprNodeColumnEvaluator.java:98) at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:76) ... 15 more FAILED: Execution Error, return code 2 from org.apa