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
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
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
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
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
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
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