Grokbase › Groups › Hive › user › August 2009
FAQ

Hive > user > August 2009

Search Discussions

44 discussions - 187 posts

  • I migrated from Hive-0.30 to Hive-trunk (r802989 compiled against Hadoop 0.18.3), copied over metastore_db & the conf directory. Output compression used to work with my earlier Hive installation, but ...
    Saurabh NandaSaurabh Nanda
    Aug 13, 2009 at 4:14 am
    Aug 25, 2009 at 12:18 pm
  • Here's what I'm trying: ResultSet rs=st.executeQuery("show tables"); while(rs.next()) { System.out.println(rs.getString(1)); } The while loop never terminates, after going through the list of tables, ...
    Saurabh NandaSaurabh Nanda
    Aug 4, 2009 at 7:48 am
    Aug 7, 2009 at 2:08 am
  • When I run hive in cli mode, I add the hive_contrib.jar file using this command: hive add jar lib/hive_contrib.jar Is there a way to do this automatically when running hive in hwi or hiveserver ...
    VijayVijay
    Aug 23, 2009 at 2:19 am
    Aug 27, 2009 at 3:30 am
  • In the Hive paper <Hive - A Warehousing Solution Over a MapReduce Framework , the section 5 describes the FUTURE WORK of Hive. I want to get more detail of following tow points: (1) Hive currently ...
    Schubert ZhangSchubert Zhang
    Aug 5, 2009 at 7:06 am
    Aug 10, 2009 at 7:35 pm
  • Hi I was wondering if anyone has thought about the possibility of having dynamic partitioning in Hive? Right now you typically use LOAD DATA or ALTER TABLE to add new partitions. It would be great ...
    Chris GoffinetChris Goffinet
    Aug 11, 2009 at 6:16 pm
    Sep 28, 2009 at 4:47 pm
  • Hi, I built a UDF function to decode the URLs from the log files. When I run the script in Hive, i get the following error message. Is there something I should be catching beside the NULL values? ...
    Ray DuongRay Duong
    Aug 20, 2009 at 11:29 pm
    Aug 25, 2009 at 4:55 pm
  • Is the "add file" command not supported in the JDBC API? I need to use it for subsequent custom map/reduce scripts in various queries. The file is available locally to the Hive server. 09/08/10 ...
    Saurabh NandaSaurabh Nanda
    Aug 10, 2009 at 5:12 am
    Aug 12, 2009 at 4:47 am
  • This probably explains the failure of those links. ASF infra is already looking at it. Ashish -----Original Message----- From: Giridharan Kesavan Sent: Wednesday, August 05, 2009 8:46 PM To: ...
    Ashish ThusooAshish Thusoo
    Aug 6, 2009 at 6:12 pm
    Aug 11, 2009 at 4:00 am
  • Hi, I'm trying to set up a MySQL metastore for Hive and I'm getting the exceptions shown below. If anyone could shed some insight as to why this is happening, it would be greatly appreciated. My ...
    Bill GrahamBill Graham
    Aug 5, 2009 at 5:38 pm
    Aug 5, 2009 at 6:49 pm
  • I've finally given up waiting for the nightly builds and have decided to build Hive from trunk. Here's the command that I'm using: ant -Dhadoop.version=0.18.3 package When I've instructed to build ...
    Saurabh NandaSaurabh Nanda
    Aug 11, 2009 at 5:38 am
    Aug 11, 2009 at 9:01 am
  • Hi all, It seems SerDe read files line by line. And each time I only get one line. But in my files, some lines actually do not represent records, e.g. some lines just represent the meta data of ...
    Zhang jianfengZhang jianfeng
    Aug 5, 2009 at 10:20 am
    Aug 6, 2009 at 7:36 am
  • I thought one map only job is ok. try hive explain insert overwrite table tmp partition(dt=1) select bar, foo from pokes; Thanks, Min -- My research interests are distributed systems, parallel ...
    Min ZhouMin Zhou
    Aug 4, 2009 at 3:02 am
    Aug 6, 2009 at 4:27 am
  • Hi Ashish, thanks for help! 1) regarding the group-by-week, it was entirely my fault... I miswrote the function... to get grouping by week one needs to have FIELD: date_add('2007-12-31', ...
    Andraz ToriAndraz Tori
    Aug 4, 2009 at 2:22 pm
    Aug 5, 2009 at 3:15 pm
  • Can I pass parameters to custom map/reduce scripts like this: from try_hits select transform ip_address, aid, uid using 'parse_logs.rb MY_PARAM_HERE' as ip_address, aid, uid I've tried it, and it ...
    Saurabh NandaSaurabh Nanda
    Aug 4, 2009 at 12:43 pm
    Aug 4, 2009 at 6:21 pm
  • I am getting this error... 09/08/28 23:19:56 WARN mortbay.log: Failed startup of context org.mortbay.jetty.webapp.WebAppContext@203c31{/hwi,${HIVE_HOME}/lib/hive-hwi.war} ...
    Edward CaprioloEdward Capriolo
    Aug 29, 2009 at 3:32 am
    Sep 10, 2009 at 12:46 am
  • http://www.hadooper.cn/hadoop/cgi-bin/moin.cgi/thirdcfp Time : Sunday, November 15, 2009 City: Beijing, China Sponsored by Yahoo!, Cloudera Organized by hadooper.cn Website: ...
    He YongqiangHe Yongqiang
    Aug 21, 2009 at 4:22 pm
    Sep 2, 2009 at 1:04 am
  • The other_properties column in log_table is also of the same type. We are using such a query to merge small files in our tables. We get the following array index out of bounds exceptions from all the ...
    Eva TseEva Tse
    Aug 31, 2009 at 4:07 am
    Aug 31, 2009 at 9:58 pm
  • Hi, I'm quite new to hive and so far everything has been working very good. I'm able to setup a small vm-based cluster, ingest a lot of our access logs and generate some pretty neat reports mostly to ...
    VijayVijay
    Aug 20, 2009 at 11:44 pm
    Aug 23, 2009 at 2:50 am
  • Hello hive users, I am getting the following exception while running bin/hive java.io.IOException: Permission denied at java.io.UnixFileSystem.createFileExclusively(Native Method) at ...
    Vinay guptaVinay gupta
    Aug 20, 2009 at 7:30 pm
    Aug 21, 2009 at 9:05 am
  • I get correct result if I run: hive -e "select count(1) from blah blah" But I get no result if I run: nohup hive -e "select count(1) from blah blah" In both cases, hive exited with 0 (success). Very ...
    Steven WongSteven Wong
    Aug 20, 2009 at 10:22 pm
    Aug 21, 2009 at 2:24 am
  • Hi all, I have some udfs and my own SerDe. Each time I start Hive, I have to execute command: add jar hive_contrib.jar Is there any way to add this jar automatically ? And Can Hive detect the jar ...
    Zhang jianfengZhang jianfeng
    Aug 17, 2009 at 6:42 am
    Aug 19, 2009 at 6:09 am
  • Hi, I have been using the following tutorial to run hive queries on amazon ec2 hadoop cluster http://wiki.apache.org/hadoop/Hive/Hi... I can ssh into the master node with the following command ssh -i ...
    Sumit khannaSumit khanna
    Aug 14, 2009 at 5:27 pm
    Aug 14, 2009 at 7:12 pm
  • Hi, I have some questions about using SELECT with UNION. I have a number of access log files that I want to process to select counts per day matching a specific pattern in the URL. This is very ...
    VijayVijay
    Aug 13, 2009 at 11:43 pm
    Aug 14, 2009 at 1:00 am
  • Hey all, Is there any news on having an 'INSERT APPEND TABLE' rather than forcing use of OVERWRITE? Is there another alternative at present other than INSERT to a temp table and doing a 'copy' of the ...
    Neal RichterNeal Richter
    Aug 8, 2009 at 6:59 pm
    Aug 13, 2009 at 4:05 am
  • I have a simple hadoop cluster setup with a couple of machines (one master running everything and one additional slave). I have hive configured with the right hive-site.xml file pointing the ...
    VijayVijay
    Aug 12, 2009 at 12:51 am
    Aug 12, 2009 at 4:27 am
  • We are running a Hive query like the following: from (select sum (c.countrow) as countrow, c.c_id as c_id, f.dt_id as dt_id, f.xid as xid, f.esn as esn, f.hour as hour from session_facts f join ...
    Eva TseEva Tse
    Aug 28, 2009 at 2:09 am
    Aug 28, 2009 at 10:20 pm
  • I am unable to running a specifc ant test on one q file in contrib... contrib]$ ant -Dtestcase=TestCliDriver -Dqfile=dboutput.q test This does not work: Running from the svn root results in the ...
    Edward CaprioloEdward Capriolo
    Aug 26, 2009 at 3:11 pm
    Aug 27, 2009 at 12:17 am
  • Hi, I just upgraded hive by taking the latest trunk and building it and installing it in the same path as before. But after the upgrade, "show tables;" returns nothing...? Did I miss some step? I ...
    Vinay guptaVinay gupta
    Aug 26, 2009 at 12:19 am
    Aug 26, 2009 at 12:25 am
  • There are too many mappers in Hive. Table has approximately 50K rows, number of bytes = 5,654,500. the query is select count(1) from TABLE group by COLUMN There are only 2 nodes. On the Web UI I can ...
    Ravi JagannathanRavi Jagannathan
    Aug 25, 2009 at 8:08 pm
    Aug 25, 2009 at 8:57 pm
  • I have a simple query like this (identify hosts that have more than one request): select host, count(1) as cnt from accesslogs where cnt 1 group by host; and it throws the error Invalid Table Alias ...
    VijayVijay
    Aug 21, 2009 at 1:55 am
    Aug 21, 2009 at 3:23 am
  • Folks, I have a table with this schema: (int key, values MAP<String, String ). I want to fetch the data from the table into local Map in my java code. Following the hive JDBC example, I did : String ...
    Michal shmueliMichal shmueli
    Aug 20, 2009 at 10:01 am
    Aug 20, 2009 at 6:18 pm
  • Hi, i launched a cluster using hadoo-ec2 scripts. I then sshed into the masternode After i log into hive i tried creating a table hive create external table kv (key int, values string) location ...
    Sumit khannaSumit khanna
    Aug 14, 2009 at 7:08 pm
    Aug 18, 2009 at 7:24 am
  • We currently run hive and store all our data in a warehouse on /user/hive/warehouse. Now we want to move the original warehouse from /user/hive/warehouse to new /user/hive/$USER/warehouse and retain ...
    Eva TseEva Tse
    Aug 13, 2009 at 2:19 am
    Aug 18, 2009 at 1:24 am
  • What is the best way to get debug info to the Hive devs if this happens again? - Neal Starting Job = job_200907281406_0792, Tracking URL = ...
    Neal RichterNeal Richter
    Aug 9, 2009 at 3:24 pm
    Aug 14, 2009 at 5:34 am
  • Hi to all Hivers out there! Does Hive currently support column-based storage? For example, can we use HBase tables as Hive table inputs for HQL? Thanks in advance, Haggai
    Haggai RoitmanHaggai Roitman
    Aug 4, 2009 at 1:14 pm
    Aug 4, 2009 at 2:19 pm
  • We discovered a problem where loading into a new partition in hive w/o specifying Œoverwrite¹ doesn¹t work. If the specified partition does not exist yet, running the following statement would not ...
    Eva TseEva Tse
    Aug 1, 2009 at 1:28 am
    Aug 3, 2009 at 7:08 pm
  • Hi all, I’d like to use my own serde to load my data, so I want to first test it in local mode. Does Hive has a local mode like Pig ? So that I can debug the program in eclipse ? Thank you. Jeff zhang
    Zhang jianfengZhang jianfeng
    Aug 2, 2009 at 3:57 pm
    Aug 3, 2009 at 4:59 pm
  • Hi, We have some old map-reduce scripts that store the results into key - value, value, value pairs. What is the best way to load the data into Hive and then transpose (shuffle) the data into value - ...
    Ray DuongRay Duong
    Aug 31, 2009 at 5:24 pm
    Aug 31, 2009 at 5:24 pm
  • Hadoop Fans, please pardon the short notice, but we wanted to let you know that we are offering a 3 day training program at the end of the month in San Francisco. There is a $300 discount for those ...
    Christophe BiscigliaChristophe Bisciglia
    Aug 14, 2009 at 2:03 am
    Aug 14, 2009 at 2:03 am
  • G Sent via BlackBerry from Vodafone -----Original Message----- From: hive-user-digest-help@hadoop.apache.org Date: 10 Aug 2009 05:13:06 To: <hive-user@hadoop.apache.org Subject: hive-user Digest 10 ...
    Andraž ToriAndraž Tori
    Aug 12, 2009 at 4:19 pm
    Aug 12, 2009 at 4:19 pm
  • Hi. Can someone clarify the use of structs as a complex data type for me ? S.x S is a struct returns the x field of S e.g for struct foobar {int foo, int bar} foobar.foo returns the integer stored in ...
    Matt PestrittoMatt Pestritto
    Aug 6, 2009 at 3:36 pm
    Aug 6, 2009 at 3:36 pm
  • When setting HIVE_AUX_JARS_PATH, "hive" starts ok, but "hive --service hiveserver" fails. If HIVE_AUX_JARS_PATH is not set, then hive server starts without problems. What am I doing wrong? Also: when ...
    Andraz ToriAndraz Tori
    Aug 5, 2009 at 9:46 am
    Aug 5, 2009 at 9:46 am
  • We have added some examples and general guide on how to write a new SerDe and UDF/UDAF. Please see http://www.slideshare.net/ragho/hive-user-meeting-august-2009-facebook Page 59-87 -- Yours, Zheng
    Zheng ShaoZheng Shao
    Aug 5, 2009 at 5:09 am
    Aug 5, 2009 at 5:09 am
  • Hadoop Fans, it looks like most of you prefer to have this on Thursday (November 5th), so that's what we'll plan for. Anyone is welcome to come to this meetup, even if you don't attend ApacheCon. ...
    Christophe BiscigliaChristophe Bisciglia
    Aug 5, 2009 at 2:31 am
    Aug 5, 2009 at 2:31 am
Aug 2009
Group Navigation
period‹ prev | Aug 2009 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions44
posts187
users29
websitehive.apache.org

29 users for August 2009

Saurabh Nanda: 45 posts Zheng Shao: 26 posts Edward Capriolo: 13 posts Vijay: 13 posts Ashish Thusoo: 12 posts Bill Graham: 9 posts Prasad Chakka: 8 posts Raghu Murthy: 8 posts Andraž Tori: 5 posts Eva Tse: 5 posts Neal Richter: 4 posts Ray Duong: 4 posts Sumit khanna: 4 posts Zhang jianfeng: 4 posts Frederick Oko: 3 posts He Yongqiang: 3 posts Schubert Zhang: 3 posts Vinay gupta: 3 posts Chris Goffinet: 2 posts Christophe Bisciglia: 2 posts
show more
Archives