trouble starting hiveserver2

Hi, I am unable to start service hiveserver2 on windows. I am starting this service to configure ODBC connection to Excel. I am issuing the following command to start the service: hive.cmd --service hiveserver2 It is not throwing any errors. When I am running with echo on option. I can see

Hive or phoenix

Hi, I am in dilemma to go ahead with Hive or phoenix. My requirement is achieving Low Latency for the query. I went through both one with suitable records of data and I got following output. 1. Hive ran all aggregation query with help

Re: Hive or phoenix

Ever tried Presto for simpler , yet faster alternative option ? Might help if used in conjunction with hive (i repeat it is not a replacement, but a complement) regards Dev On Thu, Sep 18, 2014 at 3:18 PM, Prakash Hosalli prakash.hosa...@syncoms.com wrote: Hi, I am in

Handling updates to Bucketed Table

Hi, I would like to know how to handle frequent updates to bucketed tables. Is there a way to update without a rebuild ? I have a monthly partition for a table with buckets. But I have to update the table every day. Is there a way to achieve this without a rebuild of this partition every

Re: Handling updates to Bucketed Table

When you bucket the data in a partition, there will be a file created for each of your bucketing key. Now if you add more data to the same bucket that means that file would need to rebuild I would prefer a partition on day level under month level where I write the data once a day and bucket the

RE: run tpcds queries

Probably a question for hive user/dev mailing lists. *From:* Grandl Robert [mailto:rgra...@yahoo.com] *Sent:* Wednesday, September 17, 2014 4:00 PM *To:* u...@tez.apache.org; user@hive.apache.org; Grandl Robert *Subject:* Re: run tpcds queries Hmm. It seems that the problem is some columns

Re: Handling updates to Bucketed Table

Thx Nitin. I just wanted to confirm before I give up. I'll probably do a daily partition and see how it goes. Thanks. On Thursday, September 18, 2014 12:30 PM, Nitin Pawar nitinpawar...@gmail.com wrote: When you bucket the data in a partition, there will be a file created for each of

Split the output file and name them

My output file part-r- at hive/warehouse/path/to/output_table_name/part-r- has following content inside emp1_id emp1_name emp1_salary emp1_address emp1_dob emp1_joiningdate emp2_id emp2_name emp2_salary emp2_address emp2_dob emp2_joiningdate emp3_id emp3_name emp3_salary emp3_address

Re: Handling updates to Bucketed Table

Hi all, Very interesting question. In my case, I have date partition and I am using 8 buckets that are sorted on id. I am wondering what when adding new data to this table. Data will be put in the correct partition, but will it be bucketed? Thanks for your help, Alain On 18 Sep 2014, at

Re: Split the output file and name them

Anusha , I think you have to write a MapReduce and use Multipleoutput To split your output Thanks Karthik On Sep 18, 2014, at 15:36, anusha Mangina anusha.mang...@gmail.com wrote: My output file part-r- at hive/warehouse/path/to/output_table_name/part-r- has following content