Re: ALTER TABLE RENAME TO fully qualified name

2014-03-13 Thread chenchun
Navis, I have already done that, can you take a look? see https://issues.apache.org/jira/browse/HIVE-2584 -- chenchun On Friday, 14 March, 2014 at 11:50 AM, Navis류승우 wrote: > HIVE-4064 is expected to solve this kind of problems in hive but not > in progress even it's not that hard to imple

Re: Job killed on HiveServer2 restart

2014-03-13 Thread Navis류승우
User provided classes (by adding jars) should be unloaded when the session is closed. https://issues.apache.org/jira/browse/HIVE-3969 is about that but it's not resolved yet. Thanks, Navis 2014-03-12 8:56 GMT+09:00 Ashu Pachauri : > We use Hive-0.12 and are planning to use HiveServer2 with cloude

Re: ALTER TABLE RENAME TO fully qualified name

2014-03-13 Thread Navis류승우
HIVE-4064 is expected to solve this kind of problems in hive but not in progress even it's not that hard to implement. I'll take a look at it when I'm free. Thanks, Navis 2014-03-13 22:08 GMT+09:00 Clay McDonald : > Hello everyone, I'm running Hive 0.12.0 and I thought that support for > moving

Re: Hive - Sorting on the Partition Column data type Int . Output is Alphabetic Sort

2014-03-13 Thread Stephen Sprague
wow. its still sorting based on string context. ok, some followups. 1. did you start clean? ie. did you do a "drop table moiz_partition_test" before you started? 2. lets see the output of "show create table moiz_partition_test" (if that doesn't work [its hive v0.11 i think] lets see "desc mo

ALTER TABLE RENAME TO fully qualified name

2014-03-13 Thread Clay McDonald
Hello everyone, I'm running Hive 0.12.0 and I thought that support for moving tables between database was added by using ALTER TABLE RENAME TO fully qualified name. Here is what I executing; ALTER TABLE default.sale_reports RENAME TO sales_database.sale_reports; Thanks, Clay

RE: Hive - Sorting on the Partition Column data type Int . Output is Alphabetic Sort

2014-03-13 Thread Arafat, Moiz
Hi Stephen, I followed your approach and still got the same result 1) hive> CREATE TABLE moiz_partition_test > (EVENT_DT STRING) partitioned by > ( > PARTITION_HR INT > ) > ROW FORMAT DELIMITED > FIELDS TERMINATED BY '09' > location '/user/moiztcs/moiz_partition_test'