Search Discussions
-
Hi, has the Hive client the possibility to give back the job id of the job created when running a query? I need that for tracking. Greetings Tim Bittersohl Software Engineer ...
Tim Bittersohl
Feb 27, 2013 at 5:36 pm
Mar 5, 2013 at 12:25 pm -
13
Hive Queries
I am looking for a relatively efficient way of transferring data between a remote server and Hive without going through the hassle of storing the data first on memory before loading it to Hive. hurt ...Cyrille Djoko
Feb 15, 2013 at 6:45 pm
Feb 25, 2013 at 4:28 pm -
Hello, I downloaded the source code from ptf-windowing branch and build the dist based on that. Now when I try to make use of windowing function using the following ql, I get an error as shown ...
Neelesh gadhia
Feb 22, 2013 at 10:05 pm
Feb 26, 2013 at 3:57 am -
Hi, I have implemented a simple UDAF for top-n-percent as follows: import java.util.ArrayList; import java.util.Collections; import org.apache.hadoop.hive.ql.exec.UDAF; import ...
Abhishek Bhattacharya
Feb 8, 2013 at 10:05 pm
Feb 14, 2013 at 6:30 pm -
Hi I'm experiencing the following problem when running a simple query under hive-0.10. I'm using the stock release package with CDH-4.1 The query need to execute map-reduce job for this to happen ...
Marcin Cylke
Feb 13, 2013 at 3:14 pm
Mar 18, 2013 at 5:30 pm -
Hello Hive Users, I am writing a program in java which is bundled as JAR and executed using hadoop jar command. I would like to access hive metadata (read partitions informations) in this program. I ...
Parag Sarda
Feb 11, 2013 at 11:00 pm
Feb 12, 2013 at 5:31 pm -
Hi guys, I'm writing you because I experienced a very strange problem which probably affects all Hive distribution. I made a small "only main function" Java program where I'm only connecting to my ...
Gabor Makrai
Feb 4, 2013 at 10:45 am
Feb 11, 2013 at 8:11 pm -
Hi all, I new to Apache Hive and I am doing some test to see if it fits my needs, one of the questions I have if it is possible to "peek" for the next row in order to find out if the values should be ...
Martijn van Leeuwen
Feb 2, 2013 at 7:21 pm
Feb 4, 2013 at 7:47 am -
Hi, I have just started learning about hive. I have configured Hive to use mysql as the metastore instead of derby. If I wish to use GRANT and REVOKE commands, i can use it with any user. A user can ...
Sachin Sudarshana
Feb 22, 2013 at 10:45 am
Feb 23, 2013 at 10:41 pm -
Hello all, I am trying to join two tables, the smaller being of size 4GB. When I set hive.mapjoin.smalltable.filesize parameter above 500MB, Hive tries to perform a local task to read the smaller ...
Mayuresh Kunjir
Feb 7, 2013 at 7:39 pm
Feb 16, 2013 at 12:09 am -
I stumbled across the little documented reflect function today. I've always known about it, but java scares me if it's not in a cup so I didn't dig. Well today I dug, and found an awesome use case ...
John Omernik
Feb 14, 2013 at 4:39 am
Feb 19, 2013 at 3:10 pm -
Hi All, Are there anyways to close the long running hive query through hive-jdbc? Since when ever Hive hangs, my application also hang, So I want to close the hive connection forcefully after a ...
Kugathasan Abimaran
Feb 7, 2013 at 1:06 pm
Mar 19, 2013 at 4:18 am -
As part of our daily workflow, we're running a few hundred hive queries that are coordinated through oozie. Recently we're encountering issues where on average a job or two fails - and never the same ...
James Warren
Feb 5, 2013 at 8:22 pm
Feb 26, 2013 at 5:41 am -
Hi All, I just get started with Hive. I already installed Hive and finished a few examples. Would you please give me some suggestions on a few good books or tutorials for me to continue? Many ...
William Kang
Feb 24, 2013 at 4:43 pm
Feb 26, 2013 at 2:29 am -
Hi, This is Kumar, and this is my first question in this group. I have a requirement to implement ROW_NUMBER() from Teradata in Hive where partitioning happens on multiple columns along with multiple ...
Kumar mr
Feb 21, 2013 at 7:33 am
Feb 22, 2013 at 1:44 am -
Hi, I am using this syntax to add comments for all columns :- CREATE EXTERNAL TABLE test ( c STRING COMMENT 'Common class', time STRING COMMENT 'Common time', url STRING COMMENT 'Site URL' ) ...
Chunky Gupta
Feb 21, 2013 at 11:17 am
Feb 21, 2013 at 1:17 pm -
Hello, I am a Newbie to using UDF's on hive. But implemented these GenericJDF ( https://issues.apache.org/jira/browse/HIVE-2361 ) on hive 0.9.0 and hadoop 1.1.1. Was able to add jar to hive hive ...
Neelesh gadhia
Feb 14, 2013 at 8:28 am
Feb 15, 2013 at 5:47 pm -
I'm trying to create a series of external tables for a time series of data (using the prebuilt Cloudera VM). The directory structure in HDFS is as such: /711 /712 /713 /714 /715 /716 /717 Each ...
Joseph D Antoni
Feb 15, 2013 at 4:29 pm
Feb 15, 2013 at 5:06 pm -
Hi all, I'm occasionally getting the following error, usually after running an expensive Hive query (creating 20 or so MR jobs): *** Error during job, obtaining debugging information... Examining ...
Krishna Rao
Feb 7, 2013 at 10:46 am
Feb 7, 2013 at 9:17 pm -
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 :- ...
Chunky Gupta
Feb 18, 2013 at 12:44 pm
Feb 18, 2013 at 5:01 pm -
i want to change my HIVE/HDFS directory.. how can i transfer data which resides in HDFS to some other directory ? either i have have to use sqoop-export followed by sqoop-import to new location?? or ...
Hamza Asad
Feb 12, 2013 at 4:50 pm
Feb 12, 2013 at 5:13 pm -
Does hive automatically runs on multi node as i configured hadoop on multi node OR i have to explicitly do its configuration?? -- *Muhammad Hamza Asad*
Hamza Asad
Feb 21, 2013 at 9:27 am
Feb 21, 2013 at 11:11 am -
Folks, I was wondering if any one is aware of a way to generate Hive DDL scripts using the existing metastore which in our case is in postgres. We have a few tables which have been historically ...
Murtaza Doctor
Feb 15, 2013 at 5:42 am
Feb 16, 2013 at 12:12 am -
Hi, I am storing counters (long value) in HBase table. I have created Hive Table like this - CREATE EXTERNAL TABLE hbase_hive_counters(value map<string,bigint , row_key int) STORED BY ...
Ashish Nigam
Feb 14, 2013 at 2:24 pm
Feb 14, 2013 at 5:17 pm -
Is it possible to INSERT INTO TABLE t SELECT FROM where t has a column with a STRUCT? Based on http://grokbase.com/t/hive/user/109r87hh3e/insert-data-into-a-column-of-complex-type I thought perhaps ...
Michael Malak
Feb 13, 2013 at 7:26 pm
Feb 13, 2013 at 10:53 pm -
Dear all, how can i change default directory of HIVE/HDFS i.e /user/hive/warehouse to my own customized directory? -- *Muhammad Hamza Asad *
Hamza Asad
Feb 13, 2013 at 8:15 am
Feb 13, 2013 at 8:41 am -
Hi, I tried to build Hive0.10.0 from source by doing the following: svn co http://svn.apache.org/repos/asf/hive/trunk hive sudo ant package It built fine and I got the dist folder as expected, but ...
Eric Chu
Feb 26, 2013 at 7:39 pm
Mar 2, 2013 at 6:51 am -
I am using Hive 0.9.0, while creating external table create external table if not exists table1 ( Id int, Name string, PName string, timestamp string ) row format delimited fields terminated by '\t' ...
Abhishek Gayakwad
Feb 25, 2013 at 12:34 pm
Feb 25, 2013 at 1:39 pm -
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 ...
Aditya Rao
Feb 18, 2013 at 2:16 pm
Feb 21, 2013 at 12:35 pm -
Hi, Currently the output file columns of my query is separate by "^A", I need my output to be separated by tab. Can anybody help me in setting this ? I more doubt, I want to limit the number of lines ...
Chunky Gupta
Feb 20, 2013 at 6:53 am
Feb 20, 2013 at 6:10 pm -
Hi all, In Hive over HBase case, how to configure and get Hive as HBase client to reference hbase-site.xml (for example the one in /etc/hbase/conf)? In this case it's necessary to do that since ...
Zheng, Kai
Feb 17, 2013 at 9:11 am
Feb 18, 2013 at 2:25 am -
Hi, Where can I get a install /download of Hive 0.7.0 or 0.7.1? Thx... Regards, Vince George Composite Software Mobile: 201-519-3777
Vince George
Feb 15, 2013 at 7:08 pm
Feb 15, 2013 at 7:32 pm -
Hi, I have a log file which has timestamp in format "YYYY-MM-DD-HH:MM:SS". But since the timestamp datatype format in hive is "YYYY-MM-DD HH:MM:SS". I created a table with datatype of that column as ...
Chunky Gupta
Feb 13, 2013 at 9:43 am
Feb 13, 2013 at 2:44 pm -
I am trying to do a union, group by, and multi insert all at once. I know this convoluted but I what I am trying to do is avoid having to scan through the original table more than once... if I can ...
John Omernik
Feb 12, 2013 at 3:35 am
Feb 12, 2013 at 3:00 pm -
The next Bay Area Hive User Group Meetup is tomorrow, Tuesday, February 12th at the offices of KIXEYE in San Francisco. The format will be a series of short (15 min) talks followed by un-conference ...
Carl Steinbach
Feb 11, 2013 at 5:57 pm
Feb 12, 2013 at 1:06 am -
Hi All, I ran this :- hive show partitions tab_name; and got this error :- FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT `THIS`.`PART_NAME` AS ...
Chunky Gupta
Feb 6, 2013 at 1:05 pm
Feb 7, 2013 at 10:17 am -
Hi all, I am running tests on Hive auto convert join. From the source code, it seems the conditional task will consider the intermediate table size and run the local task for generating hashtable on ...
Zhong Wang
Feb 6, 2013 at 1:29 pm
Feb 7, 2013 at 7:25 am -
Anyone use the RHive connector for R? I'm having trouble with the configuration steps on Github and was looking for any additional documentation that would be available. Thanks.
Daniel Mason
Feb 23, 2013 at 11:05 pm
Feb 24, 2013 at 9:44 am -
Hi, I am a newbie for Hive. I was assigned a job to do a lot of queries with similar structure. I just want to ask if there is a way to define functions like other programming languages so that I can ...
Yu PENG
Feb 23, 2013 at 1:10 am
Feb 23, 2013 at 1:20 am -
hi folks, I have a quick question, suppose I create a table in hive by a user and after sometime I want to change the owner of the table. 1- how can I change the owner of the table. 2- does I also ...
Hadoop hive
Feb 20, 2013 at 9:43 am
Feb 21, 2013 at 5:59 pm -
Hello! I use Hive 0.7.1 over Hadoop 0.20.2 (CHD3u3) on 70 nodes cluster. I have a trouble with query like this: *FROM* ( *SELECT* *id*, {expressions} *FROM* table1 *WHERE* day='2013-02-16' *AND* ...
Павел Мезенцев
Feb 21, 2013 at 11:45 am
Feb 21, 2013 at 3:59 pm -
Hi guys, I plan to bucket a table by "userid" as I'm going to do intense calculation using "group by userid". there are about 110 million rows, with 7 million unique userid, so my question is what is ...
Echo Li
Feb 21, 2013 at 12:20 am
Feb 21, 2013 at 1:44 am -
hi , I write a hive like : hive -e " set hive.exec.compress.output=true; set mapred.output.compression.codec=org.apache.hadoop.io.compress.GzipCodec; set hive.merge.mapredfiles=true; set ...
柏健
Feb 17, 2013 at 4:29 am
Feb 17, 2013 at 4:49 am -
Hi, intern here. My setup is the following, Hadoop 1.0.4, Sqoop 1.4.2, Hive 0.9.0 Hardware: Memory 495.6 MiB Processor Intel(R) Pentium(R) 4 CPU 2.66GHz Ubuntu 10.04 Lucid I wrote a small program ...
Cd
Feb 14, 2013 at 5:41 pm
Feb 14, 2013 at 6:24 pm -
Hi everybody, I hope you'll be able to help me understand why our Hive server occasionally starts throwing "HiveException: Unable to fetch table <same table name " and subsequently noe JDBC calls get ...
Jakub Holy
Feb 8, 2013 at 12:05 pm
Feb 8, 2013 at 12:59 pm -
hi, i created a external table like this create external table test_tb *** location <some hdfs dir , it was no problem now i want to add a partition to this table, so i tried alter table test_tb add ...
Huo Zhu
Feb 5, 2013 at 1:40 pm
Feb 6, 2013 at 8:29 pm -
Hi, Is there a way to set the hive statement query timeout in hive jdbc driver? -- Thanks, With Regards, Abimaran
Kugathasan Abimaran
Feb 6, 2013 at 3:37 am
Feb 6, 2013 at 9:32 am -
Hi, Just in case anyone else ever runs into this. Lately our cluster kept on killing itself with an OOM message in the kernel log. It took me a while to realize why this happened since no single ...
Bennie Schut
Feb 5, 2013 at 8:12 am
Feb 5, 2013 at 4:39 pm -
The following active Hive PMC members have cast votes: Carl Steinbach: +1, +1 Ashutosh Chauhan: +1, +1 Edward Capriolo: +1, +1 Ashish Thusoo: +1, +1 Yongqiang He: +1, +1 Namit Jain: +1, +1 Three ...
Carl Steinbach
Feb 4, 2013 at 10:28 pm
Feb 5, 2013 at 3:11 am -
Guys, I'm seeing the following stacktrace when trying to do a join between three tables in Hive 0.8.1. The statement looks like this: select * from table1 t1 inner join table2 t2 on t1.field1 = ...
Juan P.
Feb 1, 2013 at 6:02 pm
Feb 1, 2013 at 7:40 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 71 |
posts | 268 |
users | 100 |
website | hive.apache.org |
100 users for February 2013
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)