Perhaps worth posting the error. Some might know what the error means.
Also a bit unrelated to hive but please do yourself a favor and don't use float
to store monetary values like salary. You will get rounding issues at some
point in time when you do arithmetic on them. Considering you are usin
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
Date: Fri, 8 Mar 2013 09:09:49
To: user@hive.apache.org; 'Sai Sai'
Reply-To: user@hive.apache.org
Subject: RE: Accessi
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, wrote:
> Hi Sai
>
>
> You can do it as
> Selec
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 wrote:
> I have added the jar files successfully like this:
>
>
>
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 course,
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 impor
This is in HIVE-0.9.0
hive> list
jars;/nfs_home/common/userlibs/google-collections-1.0.jar/nfs_home/common/userlibs/elephant-bird-hive-3.0.7.jar/nfs_home/common/userlibs/protobuf-java-2.3.0.jar/nfs_home/common/userlibs/elephant-bird-core-3.0.7.jarfile:/usr/lib/hive/lib/hive-builtins-0.9.0-cdh4.1.
--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 wrote:
> This is in HIVE-0.9.0
>
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. AD
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
fi
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.
O
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
hive.stats.dbconnect
This is now fixed via HIVE-4074. Docs are now online again. Thanks, Gunther!
Ashutosh
On Tue, Mar 5, 2013 at 6:42 PM, 周梦想 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 found on th
16 matches
Mail list logo
