How to drop the cloudera_manager_metastore_canary_test_db_hive_hivemetastore* ?

2014-10-15 Thread
Hi: There are some databases named cloudera_manager_metastore_canary_test_db_hive_hivemetastore_47eeceae20c69acc3391e93ce56ee1cc_* in my hive . When I use drop databases to delete them,Some of them are deleted,but Others can't. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.

How to execte sql in Hive through odbc in Erlang?

2014-08-29 Thread
Hi I have a qustion that execting sql in hive failed. There is my step: [root@ljxz_hd_S1_125.88.254.153_61618_A ~]# erl Erlang R16B01 (erts-5.10.2) [source] [64-bit] [smp:24:24] [async-threads:10] [hipe] [kernel-poll:false] Eshell V5.10.2 (abort with ^G) 1> odbc:start(). ok 2> {ok,Ref} = odbc:con

Re: How to merge the output file when insert data into a table

2014-08-28 Thread
I collect data from a real-time system, we have not another database. 2014-08-29 0:59 GMT+08:00 Venkat V : > Have you tried sqoop merge? > > > On Thu, Aug 28, 2014 at 7:45 AM, 王洋 wrote: > >> Hello, >> I have two table ,one is stored as textfile for loading d

Re: How to merge the output file when insert data into a table

2014-08-28 Thread
them into 1 file. For text files, you can may have to reload these 2 files > into another table with "Order By". This will force one reducer to generate > total ordering and thereby generating 1 output file. But remember if the > data size huge order by will take very long time.

How to merge the output file when insert data into a table

2014-08-28 Thread
Hello, I have two table ,one is stored as textfile for loading data from local data, the other is stored as rcfile for compressing data。 when I execute the following sql two times * insert into table tablename1 select * from tablename2* I find that there are two files in the wa