RE: Setting | Verifying | Hive Query Parameters from Java

Hi Gordon, Thanks a lot for reply. We have installed CDH4.2.0 and hive-0.10.0-cdh4.2.0. Both are working as desired. We need to set hive configuration parameter from Java while making JDBC connection. We have written a java program to execute queries on hive server with some configurations prop

Re: bucketed table problems

Thanks. :-) It's working better for me now. On Mar 7, 2014, at 17:37 , Stephen Sprague wrote: > short answer: its by position. > Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

Re: data get truncated.

Hi, did you try specifying row, field delimiter on create table ? Thanks Szehon On Fri, Mar 7, 2014 at 5:27 PM, Kim Chew wrote: > I have an input file in Sequence File format which has the format, > > which has the type > > Then I created a table, > > CREATE TABLE if not exists TEST ( >

Re: bucketed table problems

short answer: its by position.

data get truncated.

I have an input file in Sequence File format which has the format, which has the type Then I created a table, CREATE TABLE if not exists TEST ( value string) STORED AS SEQUENCEFILE; and then I load the input file to the table. However when I do a query, select value from TEST; I fou

Re: bucketed table problems

Admittedly the problem has gone away. I *think* I may have offered the schema to the bucketed table creation in the wrong order the first time...I think. All I know is the problem went away when I tried a second time. Should inserting a table into another table match the columns by name or do

Re: bucketed table problems

yeah. that's not right. 1. lets see the output of "show create table foo" 2. what version of hive are you using. On Fri, Mar 7, 2014 at 11:46 AM, Keith Wiley wrote: > I want to convert a table to a bucketed table, so I made a new table with > the same schema as the old table and specified a c

bucketed table problems

I want to convert a table to a bucketed table, so I made a new table with the same schema as the old table and specified a cluster column: create table foo_bucketed ( a string, b int, c float ) clustered by (b) into 10 buckets; Then I populate it from my original table: set hive.enforce.bucketi

Error when connecting Hive

I am getting below error when connecting to hive shell. I thought it is because of log directory issue. But even fixing the directory permission the error still exists. manish@localhost:/tmp/manish$ hive Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties

Re: Setting | Verifying | Hive Query Parameters from Java

Hi Rinku, I think yarn.nodemanager.resource.memory-mb is a static configuration prop. You can not change this dynamically. The other MR props looks OK to me. On Fri, Mar 7, 2014 at 2:58 PM, Garg, Rinku wrote: > Hi Gordon, > > > > Thanks a lot for your reply. > > > > The properties mentioned