FAQ

Hive > user > February 2013

Search Discussions

71 discussions - 268 posts

  • 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 BittersohlTim Bittersohl
    Feb 27, 2013 at 5:36 pm
    Mar 5, 2013 at 12:25 pm
  • 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 DjokoCyrille 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 gadhiaNeelesh 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 BhattacharyaAbhishek 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 CylkeMarcin 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 SardaParag 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 MakraiGabor 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 LeeuwenMartijn 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 SudarshanaSachin 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 KunjirMayuresh 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 OmernikJohn 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 AbimaranKugathasan 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 WarrenJames 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 KangWilliam 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 mrKumar 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 GuptaChunky 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 gadhiaNeelesh 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 AntoniJoseph 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 RaoKrishna 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 GuptaChunky 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 AsadHamza 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 AsadHamza 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 DoctorMurtaza 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 NigamAshish 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 MalakMichael 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 AsadHamza 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 ChuEric 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 GayakwadAbhishek 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 RaoAditya 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 GuptaChunky 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, KaiZheng, 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 GeorgeVince 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 GuptaChunky 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 OmernikJohn 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 SteinbachCarl 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 GuptaChunky 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 WangZhong 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 MasonDaniel 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 PENGYu 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 hiveHadoop 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 LiEcho 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 ...
    CdCd
    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 HolyJakub 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 ZhuHuo 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 AbimaranKugathasan 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 SchutBennie 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 SteinbachCarl 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.Juan P.
    Feb 1, 2013 at 6:02 pm
    Feb 1, 2013 at 7:40 pm
Feb 2013
12
Group Navigation
period‹ prev | Feb 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions71
posts268
users100
websitehive.apache.org

100 users for February 2013

Dean Wampler: 14 posts Chunky Gupta: 11 posts Bejoy_ks: 10 posts Edward Capriolo: 10 posts Nitin Pawar: 10 posts Mark Grover: 9 posts Neelesh gadhia: 9 posts John Omernik: 8 posts Abhishek Bhattacharya: 7 posts Hamza Asad: 7 posts Aniket Mokashi: 5 posts Bennie Schut: 5 posts Butani, Harish: 5 posts Kugathasan Abimaran: 5 posts Marcin Cylke: 5 posts Cyrille Djoko: 4 posts Gabor Makrai: 4 posts Harsh J: 4 posts Joseph D Antoni: 4 posts Martijn van Leeuwen: 4 posts
show more
Archives