Re: insert table error

Hi, The INSERT INTO ... VALUES syntax is not supported in Hive 0.13. This is a feature beyond Hive 0.14 only. -- Thanks, Raunak Jhawar On Tue, Mar 17, 2015 at 8:23 AM, 张奇迹 wrote: > thanks, it's the version's problem ,i am using 0.13.1 > > -- > From: raunak.jha...

can update aux jar during hiveserver2 running

i am using my custom serde , but when serde change, I have to restart hiverserver2 ,is there any good idear?

RE: insert table error

thanks, it's the version's problem ,i am using 0.13.1 From: raunak.jha...@gmail.com Date: Fri, 13 Mar 2015 17:12:15 +0530 Subject: Re: insert table error To: user@hive.apache.org What version of Hive are you using. INSERT INTO ... VALUES is supported only from Hive 0.14 onwards. https://cwiki.ap

RE: view over partitioned table

Hi Cobby, In your statement and I quote: “Empirical tests, by the show, suggest that indeed, partition optimization does take place. “ Do you have an example of this please? Thanks, Mich Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence C

RE: view over partitioned table

Hi Douglas, The version of hive is 0.14.0 as shown below: hive --version Hive 0.14.0 Subversion file:///Users/ghagleitner/Projects/hive-svn/rel-prep/hive-14-rel-prep -r Unknown Compiled by ghagleitner on Sat Nov 8 23:25:06 PST 2014 >From source with checksum 49c2182a0856f7917f571802a759

Reading 2 table data in MapReduce for Performing Join

Hi, I tried reading data via HCatalog for 1 Hive table in MapReduce using something similar to https://cwiki.apache.org/confluence/display/Hive/HCatalog+InputOutput#HCatalogInputOutput-RunningMapReducewithHCatalog. I was able to read successfully. Now am trying to read 2 tables, as the requiremen

Re: view over partitioned table

hi,i am using CDH 5.2 (hive 13).as for partitioned views, to my understanding they are more about abstracting a non partitioned back end. My questing is related to how and if the query optimizer can detect possible uses of partitioned column, even if it might be "masked" by a view (or multiple

Re: Hive on Spark

One more thing, "java.lang.NoSuchFieldError: SPARK_RPC_CLIENT_CONNECT_TIMEOUT", are your jar files consistent? On Mon, Mar 16, 2015 at 6:47 AM, Xuefu Zhang wrote: > It seems that your remote driver failed to start. I suggest #1: try > spark.master=local first; #2: check spark.log to find out why

Re: insert table error

What Hive version are you using? What error message did you get? Alan. zhangjp March 13, 2015 at 4:13 case fail CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3, 2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC; INSERT INTO TABLE students VAL

Re: view over partitioned table

Mich, What version of Hive are you running? Have you seen this? https://cwiki.apache.org/confluence/display/Hive/PartitionedViews - Douglas From: Mich Talebzadeh mailto:m...@peridale.co.uk>> Reply-To: mailto:user@hive.apache.org>> Date: Sun, 15 Mar 2015 19:01:57 + To: mailto:user@hive.apache.

Re: Hive on Spark

It seems that your remote driver failed to start. I suggest #1: try spark.master=local first; #2: check spark.log to find out why the remote driver fails. --Xuefu On Sun, Mar 15, 2015 at 10:17 PM, Amith sha wrote: > Hi, > > I have already added the spark-assembly jar in hive lib & here is my hi