Re:

2014-06-18 Thread Andre Araujo
This seems to be fixed by HIVE-6005, which is included in HIVE-5263. On 19 June 2014 00:25, Clay McDonald wrote: > I’m trying to run the following hive join query and get the following > error. Any suggestions? > > > > > > > > > > hive> select count(B.txn_id) AS CNT FROM txn_hdr_combined AS B

Re:

2014-06-18 Thread Andre Araujo
Could you send a "show create table" for the two tables involved? On 19 June 2014 00:25, Clay McDonald wrote: > I’m trying to run the following hive join query and get the following > error. Any suggestions? > > > > > > > > > > hive> select count(B.txn_id) AS CNT FROM txn_hdr_combined AS B JOI

Re: local-mode doesn't work?

2014-06-18 Thread Yang
also another important question: is it possible to read real hive tables on HDFS even though you are running hive in local mode? in most cases the tables are complex and it's a chore to replicate them to local and set up your derby local metastore in the case of PIG, copying these input files to l

local-mode doesn't work?

2014-06-18 Thread Yang
I tried to run hive in local mode to debug a script (possibly with UDF) so that I could attach it to eclipse for debugging. I followed the advice of https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-Hive,Map-ReduceandLocal-Mode i.e. hive> SET mapred.local.dir = /tmp/

Re: Fw: hive + tez + yarn 2.4

2014-06-18 Thread Bala Krishna Gangisetty
"set hive.execution.engine=tez" alone would suffice the Tez configuration for Hive. Make sure all necessary environmental variables are set properly like TEZ_CONF_DIR, TEZ_JARS, HADOOP_CLASSPATH et al. --Bala G. P.S: For more information: http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1-la

Fw: hive + tez + yarn 2.4

2014-06-18 Thread Grandl Robert
Not sure whether hive or tez mailing list is the best place to ask. Thanks, robert On Wednesday, June 18, 2014 10:25 AM, Grandl Robert wrote: Hi guys, I was trying to run hive atop tez atop yarn 2.4. Setting mapreduce.framework.name to yarn-tez enables tez execution engine and I can ru

JOIN QUERY ERROR: SemanticException Generate Map Join Task Error: Class cannot be created (missing no-arg constructor)

2014-06-18 Thread Clay McDonald
I'm trying to run the following hive join query and get the following error. Any suggestions? hive> select count(B.id) AS CNT FROM hdr_combined AS B JOIN upc_table AS C ON B.id = C.id; com.esotericsoftware.kryo.KryoException: Class cannot be created (missing no-arg  constructor): org.apache.