RE: Error when altering table not in default database

2014-08-06 Thread sky88088
-2584 and HIVE-4064). In the meantime, you can set the database before issuing ALTER TABLE, then reset it afterwards: USE database_name; ALTER TABLE table_A DROP PARTITION (id-1); USE DEFAULT; -- Lefty On Wed, Aug 6, 2014 at 4:47 AM, sky88088 wrote: Hi all,I encounter error when

Error when altering table not in default database

2014-08-06 Thread sky88088
Hi all,I encounter error when I was trying to alter a table not in default database. The command I type isalter table db1.table_A drop partition (id=1);Error info isFAILED: ParseException line 2:12 cannot recognize input near 'db1' '.' 'table_A' in

about bucket map join

2014-05-21 Thread sky88088
Hi all, I encounter problems when trying to run map-join for large tables by using bucketing tables.The table is partitioned into 20 buckets: create table if not exists ip_c_bucket (country string, ip_from bigint, ip_to bigint) clustered by(ip_from) into 20 buckets; For

RE: Does hive instantiate new udf object for each record

2014-03-25 Thread sky88088
It works! I really appreciate your help! Best Regards,ypg From: java8...@hotmail.com To: user@hive.apache.org Subject: RE: Does hive instantiate new udf object for each record Date: Tue, 25 Mar 2014 09:57:25 -0400 The reason you saw that is because when you provide evaluate() method, you di

RE: Does hive instantiate new udf object for each record

2014-03-24 Thread sky88088
I have implemented a simple udf for test. public class test extends UDF { private Text t; public Text evaluate () { if(t==null) { t=new Text("initialization"); } else { t=new Text("OK"); } return t; } } And the test que