I have added the jar files successfully like this:
hive (testdb) ADD JAR lib/hive-json-serde-0.3.jar;
Added lib/hive-json-serde-0.3.jar to class path
Added resource: lib/hive-json-serde-0.3.jar
hive (testdb) ADD JAR lib/json-path-0.5.4.jar;
Added
If any of the 100 rows that the sub-query returns do not satisfy the where
clause, there would be no rows in the overall result. Do we still consider
that the Hive query is verified in this case?
Regards,
Ramki.
On Wed, Mar 6, 2013 at 1:14 AM, Dean Wampler
dean.wamp...@thinkbiganalytics.com
Hi Sai
You can do it as
Select address.country from employees;
Regards
Bejoy KS
Sent from remote device, Please excuse typos
-Original Message-
From: Bennie Schut bsc...@ebuddy.com
Date: Fri, 8 Mar 2013 09:09:49
To: user@hive.apache.orguser@hive.apache.org; 'Sai
I recognize this example ;)
You reference struct elements with the dot notation, as Bejoy said, map
elements with what you tried, deductions['Federal taxes'], and arrays by
index, starting from zero, subordinates[0].
On Fri, Mar 8, 2013 at 6:35 AM, bejoy...@yahoo.com wrote:
Hi Sai
You can
Unfortunately, you have to also add the json jars to Hive's class path
before it starts, e.g.,
env HADOOP_CLASSPATH=/path/to/lib/*.jar hive
Use the appropriate path to your lib directory.
On Fri, Mar 8, 2013 at 4:53 AM, Sai Sai saigr...@yahoo.in wrote:
I have added the jar files successfully
It's odd that there is no such command. The trick Ramki mentioned is the
only one I know of. Two points about it, though:
1. It only works on Hive v0.8+.
2. I've seen a few cases where the prompt did NOT change when first used,
but starting working a little later! I have no idea why and of
Hi Venkat,
All most column have some value except these three.
Regards,
Ajit
-Original Message-
From: Venkat Ranganathan [mailto:vranganat...@hortonworks.com]
Sent: Wednesday, March 06, 2013 9:36 PM
To: user@hive.apache.org
Cc: u...@sqoop.apache.org
Subject: Re: Data mismatch when
This is in HIVE-0.9.0
hive list
--auxpath adds more jars to Hive's classpath before invoking Hive. ADD JARS
copies jars around the cluster and adds them to the task classpath, so the
jars you add aren't visible to hive itself. Annoying, but...
On Fri, Mar 8, 2013 at 11:53 AM, java8964 java8964 java8...@hotmail.comwrote:
This
Essentially anything that is part of the InputFormat needs to be in
auxlib/auxpath. Anything part of a UDF can be added with 'add jar'.
On Fri, Mar 8, 2013 at 1:01 PM, Dean Wampler
dean.wamp...@thinkbiganalytics.com wrote:
--auxpath adds more jars to Hive's classpath before invoking Hive. ADD
Hi,
Hive 0.9.0 + Elephant-Bird 3.0.7
I faced a problem to use the elephant-bird with hive. I know what maybe cause
this problem, but I don't know which side this bug belongs to. Let me know
explain what is the problem.
If we define a google protobuf file, with field name like 'dateString' (the
Do you have more than one hive process running? It looks like you're using
Derby, which only supports one process at a time. Also, you have to start
Hive from the same directory every time, where the metastore database is
written, unless you edit the JDBC connection property in the Hive config
Thanks for your attention !
No only one hive process is running and thing that bother me is smaller
query runs till completion which I invoke the same way. It is using embeded
db if that is the problem I can change it to external DB but as my smaller
query runs fine I thought this should be OK.
Hi Dileep,
Have tried to se the following values in hive and run the query again. More
info why the query may fail in the following link :
https://cwiki.apache.org/Hive/statsdev.html
set hive.stats.autogather=false;
As well as ;
set hive.stats.dbclass=jdbc:derby;
set
This is now fixed via HIVE-4074. Docs are now online again. Thanks, Gunther!
Ashutosh
On Tue, Mar 5, 2013 at 6:42 PM, 周梦想 abloz...@gmail.com wrote:
from version 0.80, the release document is not found.
http://hive.apache.org/docs/r0.10.0/
Not Found
The requested URL /docs/r0.10.0/ was not
15 matches
Mail list logo