Re: hive query fail

2012-10-03 Thread Bejoy KS
Hi Ajit Oracle as a metastore has popped up a few issues for us in the past. The most widely used metastore db is MySql which is pretty good. Regards Bejoy KS Sent from handheld, please excuse typos. -Original Message- From: Ajit Kumar Shreevastava Date: Thu, 4 Oct 2012 11:39:50 To

RE: hive query fail

2012-10-03 Thread Ajit Kumar Shreevastava
Hi All, I am using oracle as a remote metastore for hive. I want to run select count(1) from pokes; it fails. [hadoop@NHCLT-PC44-2 ~]$ hive Logging initialized using configuration in file:/home/hadoop/Hive/conf/hive-log4j.properties Hive history file=/home/hadoop/tmp/hadoop/hive_job_log_hadoop

RE: hive query fail

2012-10-03 Thread yogesh.kumar13
Hi Ajit, I have already suggested you that select command dosen't initiate map-reduce, its just dump the data. check out your network proxy setting for you node. try to give bypass proxy for the address. Regards Yogesh Kumar Dhari From: Ajit Kumar Shreevas