Re:Re: Re: How to debug Hive0.14 with Hadoop2.5.0 in Eclipse?

2014-12-22 Thread vic0777
Thanks Szehon. The --debug option works. Wantao At 2014-12-23 03:23:23, "Szehon Ho" wrote: That's true, it might be broken now. I think now most people to debug their code will build assembly using -Phadoop-2,dist, and then go to packaging/target/... and run bin/hive from there. You c

Re: Enabling Tez sessions on HiveServer2

2014-12-22 Thread Vikram Dixit
Hi Pala, With sql std auth enabled, the commands are run as user hive and not as the logged on user. Regards Vikram. On Fri, Dec 19, 2014 at 12:18 PM, Pala M Muthaia < mchett...@rocketfuelinc.com> wrote: > Yes i am using HiveServer2, but we haven't enabled SqlStdAuth yet. Are you > saying with

Re: Insert into partitioned table from unpartitioned table

2014-12-22 Thread Stéphane Verlet
sorry I did not see that the partitions columns were not in the source table You need to set the values for the partititons INSERT OVERWRITE TABLE dest_table PARTITION (year='2014', month='12', day='22') SELECT On Mon, Dec 22, 2014 at 3:37 PM, Stéphane Verlet wrote: > Specify the cols wi

Re: Insert into partitioned table from unpartitioned table

2014-12-22 Thread Stéphane Verlet
Specify the cols with the partition cols last in the select statement INSERT OVERWRITE TABLE dest_table PARTITION (year, month, day) SELECT field1 , field2, ... year, month, day FROM source_table On Mon, Dec 22, 2014 at 12:07 PM, Buntu Dev wrote: > Hi -- I got the destination table with parti

Re: Re: How to debug Hive0.14 with Hadoop2.5.0 in Eclipse?

2014-12-22 Thread Szehon Ho
That's true, it might be broken now. I think now most people to debug their code will build assembly using -Phadoop-2,dist, and then go to packaging/target/... and run bin/hive from there. You can debug changes by setting bin/hive --debug, or alternatively by setting HADOOP_OPTS to include your o

Insert into partitioned table from unpartitioned table

2014-12-22 Thread Buntu Dev
Hi -- I got the destination table with partition on columns that are not in the source table and get this error when attempting to do an INSERT OVERWRITE, how to go about fixing this? Thanks: SET hive.exec.dynamic.partition = true; SET hive.exec.dynamic.partition.mode = nonstrict; INSERT OVERWRIT

Re:Re: How to debug Hive0.14 with Hadoop2.5.0 in Eclipse?

2014-12-22 Thread vic0777
Hi Szehon, Thanks for your reply. I do not want to run bin/hive. I need to debug my changes to Hive code in Eclipse. For Hive0.11, I could build and import it into eclipse, then execute the main method in CliDriver. The hive prompt would appear in the Eclipse console, then I can type HQL stat