Re: hiveserver2 java heap space

ge or destruction. On 24 October 2016 at 10:43, Patcharee Thongtra mailto:patcharee.thong...@uni.no>> wrote: Hi, I tried to query orc file by beeline and java program using jdbc ("select * from orcfileTable limit 1"). Both failed with Caused by: java.lang.OutOfMemoryE

hiveserver2 java heap space

Hi, I tried to query orc file by beeline and java program using jdbc ("select * from orcfileTable limit 1"). Both failed with Caused by: java.lang.OutOfMemoryError: Java heap space. Hiveserver2 heap size is 1024m. I guess I need to increase this Hiveserver2 heap size? However I wonder why I

orc table with sorted field

Hi, How can I create a partitioned orc table with sorted field(s)? I tried to use sorted by keyword, but failed parse exception> CREATE TABLE peoplesort (name string, age int) partition by (bddate int) SORTED BY (age) stored as orc Is it possible to have some sorted columns? From hive ddl p

Load columns changed name

Hi, I have a hive table with a column which was changed its name. Pig is not able to load data from this column, it is all empty. Any ideas how to fix it? BR, Patcharee

Re: cannot store value into partition column

After I changed org.apache.hcatalog.pig.HCatStorer() to org.apache.hive.hcatalog.pig.HCatStorer(), it worked. Patcharee On 01/14/2015 02:57 PM, Patcharee Thongtra wrote: Hi, I am having a weird problem. I created a table in orc format: Create table

cannot store value into partition column

Hi, I am having a weird problem. I created a table in orc format: Create table create external table cossin (x int, y int, cos float, sin float) PARTITIONED BY(zone int) stored as orc location '/apps/hive/warehouse/wrf_tables/co

Re: compare float column

It works. Thanks! Patcharee On 01/13/2015 10:15 AM, Devopam Mittra wrote: please try the following and report observation: WHERE long = CAST(-41.338276 AS FLOAT) regards Devopam On Tue, Jan 13, 2015 at 2:25 PM, Patcharee Thongtra mailto:patcharee.thong...@uni.no>> wrote: Hi,

compare float column

Hi, I have a table with float columns. I tried to query based on the condition on a float column (called 'long'), but it failed (nothing returned). hive> select * from test_float where long == -41.338276; select * from test_float where long == -41.338276 Status: Finished successfully OK Time

Backend error : java.lang.String cannot be cast to java.lang.Integer

Hi, I am using hive with pig. In my pig script I tried to query and sort data from a hive table as below: query = load 'fino31' USING org.apache.hive.hcatalog.pig.HCatLoader(); z_query = FILTER query BY zone==2 and z >= 2 and z <= 9; z_order = ORDER z_query by z; dump z_order; the column 'z'

Re: alter table add more columns

can visit this link <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL>. *Warm regards,* *Mohammad Tariq* /cloudfront.blogspot.com <http://cloudfront.blogspot.com>/ On Tue, Jun 3, 2014 at 1:36 AM, Patcharee Thongtra mailto:patcharee.thong...@uni.no>> wrote

alter table add more columns

Hi, I have a table named fino31 with the following schema hive> describe fino31; OK datetimestamp zoneint z int u float v float th float qv float ph

java.lang.TypeNotPresentException: Type timestamp not present

Hi, I am using hive 0.13 and I created a table with a column date in timestamp format. When I used pig script to store data into the table I got exception java.lang.TypeNotPresentException: Type timestamp not present This is my pig script result = FOREACH result_raw GENERATE generate ToDate(