Hi Manish,
If you have data on your local file system,
You can also do something like following from your local file system, without
doing put or copyFromLocal.
$ hive -e "load data local inpath 'path on local file system' into table ;"
Thanks,
Anurag Tangri
Sent from my iPhone
On Feb 16, 201
AFAIK, 0.8 and 0.9 have same schema. Did you upgrade to 0.10 accidentally?
On Sun, Feb 17, 2013 at 9:31 PM, FangKun Cao wrote:
> Hi Sam William:
>
> Check this issue: https://issues.apache.org/jira/browse/HIVE-3649
>
> and
>
> http://svn.apache.org/repos/asf/hive/tags/release-0.10.0/metastore/
I don't know what changed. I didn't work on this SerDe myself. I'm glad
it's working now for you, though!
dean
On Mon, Feb 18, 2013 at 9:31 AM, Chunky Gupta wrote:
> Hi Dean,
>
> I was using *hive-json-serde-0.2.jar* earlier. Now I tried
> *hive-json-serde-0.3.jar
> *as you suggested and it is
Hi Dean,
I was using *hive-json-serde-0.2.jar* earlier. Now I tried
*hive-json-serde-0.3.jar
*as you suggested and it is working fine, I am getting the output as
expected.
Can you please tell me that what code change from 0.2 to 0.3 could have
solved this problem ?
Thanks,
Chunky.
On Mon, Feb
Hi Dean,
I tried with removing underscore too, and getting the same output which
means problem is not with underscore. Yes, it was an example.
Actual json file is like :-
{"colnamec":"ColNametest","colnamets":"2013-01-14","colnameip":"10.10.10.10","colnameid":"10","colnameid2":"100","colnamep":0
I personally do not find it a large problem.
1) have multiple backend hive thrift servers with ha-proxy in front
2) don't use varaible names like "x" use "myprocess1.x" to remove
possible collisions
3) experiment with hivethrift2
4) dont use zk locking + thrift (it leaks as far as I can tell (olde
Hi,
I've just recently started using Hive and I'm particularly interested about
the capabilities of the HiveJDBC interface. I'm writing an simple
application that aims to use the Hive JDBC driver to submit hive queries.
My end goal is to be able to create multiple connections using the
Hive JDBCdr
The "uname="$._u" is the correct form. We also hacked on this SerDe at
Think Big Analytics. I don't know if you'll see an improvement though.
https://github.com/thinkbiganalytics/hive-json-serde
I wonder if there's a problem handling the leading underscore?
Also, I know it's just an example, but
Hi,
I have data in s3 bucket, which is in json format and is a zip file. I have
added this jar file in hive console :-
http://code.google.com/p/hive-json-serde/downloads/detail?name=hive-json-serde-0.2.jar&can=2&q=
I tried the following steps to create table and load data :-
1. CREATE EXTERNAL T
