Grokbase Groups Hive user July 2011
FAQ

Search Discussions

56 discussions - 152 posts

  • -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
    Vikas SrivastavaVikas Srivastava
    Jul 19, 2011 at 1:05 pm
    Jul 20, 2011 at 1:10 pm
  • I'm teaching myself hive and I'm having an issue with a simple select statement. I'm using Amazon's Elastic MapReduce. I'm creating a table with some sample web log data I downloaded from a sample ...
    Sal ScalisiSal Scalisi
    Jul 6, 2011 at 10:13 pm
    Jul 8, 2011 at 1:42 am
  • Hey , i just want to use any compression in hadoop so i heard about lzo which is best among all the compression (after snappy) please any1 tell me who is already using any kind of compression in ...
    Vikas SrivastavaVikas Srivastava
    Jul 25, 2011 at 11:05 am
    Jul 28, 2011 at 4:48 am
  • Hi, I have a data on HDFS that is already stored into directories as per date. for example- /abc/xyz/yyyy-mm-d1, /abc/xyz/yyyy-mm-d2. How do I create external table with partition key as date to ...
    Aniket MokashiAniket Mokashi
    Jul 1, 2011 at 10:57 pm
    Jul 6, 2011 at 7:53 pm
  • Hi, I was playing with the Hive Authorization system.... It seems to me a user can Grant himslef privileges... Can an administrator can prohibit user to grant them self privileges? Thanks Guy Doulberg
    Guy DoulbergGuy Doulberg
    Jul 20, 2011 at 1:07 pm
    Jul 24, 2011 at 9:26 am
  • Hi guys, I've just trying to upgrade to jets3t 0.7.4 from 0.6.1, because the connection pool gets depleted after 20 requests. Now, I'm getting the following stack trace when trying to access s3. Does ...
    Wouter de BieWouter de Bie
    Jul 21, 2011 at 10:11 am
    Jul 22, 2011 at 2:59 pm
  • Hi, I have a table, which has close to a billion rows.. I am trying to create an index for the table, when I do the alter command, I always end up with map-reduce jobs with errors. The same runs fine ...
    Siddharth RamananSiddharth Ramanan
    Jul 28, 2011 at 8:20 pm
    Aug 5, 2011 at 10:02 pm
  • Hello, I'm having isssue running Hive jobs after updating from Hive 0.5 to Hive 0.7 (from CDHb4 to CDHu1). No matter what query I'm running Hive is always using one mapper. I have tried different ...
    Wojciech LangiewiczWojciech Langiewicz
    Jul 28, 2011 at 1:23 pm
    Jul 29, 2011 at 10:21 am
  • Hi, I am using the stack of hive+hbase+hadoop. We had an existing stack of: hadoop: 0.20.2 hbase: 0.20.6 hive: 0.6.0 db-derby: 10.4.2.0 And this is running well. However it doesnt have functions like ...
    MayureshMayuresh
    Jul 25, 2011 at 10:57 am
    Jul 28, 2011 at 3:12 am
  • note: this is somewhat a repost of something i posted on the CDH3 user group. apologies if that is not appropriate. i am exploring map-joins in hive. with hive.auto.convert.join=true hive tries to do ...
    Koert KuipersKoert Kuipers
    Jul 19, 2011 at 6:16 pm
    Jul 19, 2011 at 10:58 pm
  • Hello, can't import files with dynamic partioning. Query looks like this FROM cost c INSERT OVERWRITE TABLE costp PARTITION (accountId,day) SELECT c.clientId,c.campaign,c.accountId,c.day DISTRIBUTE ...
    LabtraxLabtrax
    Jul 12, 2011 at 4:06 pm
    Jul 14, 2011 at 1:24 pm
  • Hi all, I'm using Hive with the s3native FS. Today, I noticed that hive locks up after 4 queries that directly access S3 (select * from mytable limit 10). With debug logging on, I get the following ...
    Wouter de BieWouter de Bie
    Jul 6, 2011 at 4:07 pm
    Jul 11, 2011 at 6:38 am
  • Hi, I am trying to enable my clients to use MS Reporting Service (That is their demand), I tried to configure this ODBC/JDBC bridge: ...
    Guy DoulbergGuy Doulberg
    Jul 18, 2011 at 7:53 am
    Jul 19, 2011 at 11:20 am
  • Has anyone encountered the following exception? It is causing our SELECT queries to return incorrect results infrequently. 2011-07-06 13:46:40,225 WARN DataNucleus.Query (Log4JLogger.java:warn(106)) ...
    Steven WongSteven Wong
    Jul 10, 2011 at 2:25 am
    Jul 12, 2011 at 6:14 am
  • Hi, I am doing some simple tests to create table, load data using Hive. I am working on the VM provided by cloudera (https://ccp.cloudera.com/display/SUPPORT/Cloudera%27s+Hadoop+Demo+VM). I have a ...
    Yichuan (William) HuYichuan (William) Hu
    Jul 1, 2011 at 6:17 pm
    Jul 1, 2011 at 6:38 pm
  • Hi All, I can't find any reasonable documentation about being able to use Serde's. I have a JSONSerde which I use to create an external table create external table scratch.json_serde_test (user_id ...
    Ayon SinhaAyon Sinha
    Jul 29, 2011 at 7:00 am
    Jul 29, 2011 at 9:32 pm
  • Hey can any1 tell me how to use or install patches given in jira for hadoop or hive!! -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
    Vikas SrivastavaVikas Srivastava
    Jul 27, 2011 at 11:20 am
    Jul 27, 2011 at 1:22 pm
  • We have database dumps with TAB delimiters. The fields with TAB have them escaped in the dumped text file. But HIVE does not respect escaped delimiters so create external table scratch.delete_me (a ...
    Ayon SinhaAyon Sinha
    Jul 26, 2011 at 9:14 pm
    Jul 26, 2011 at 9:52 pm
  • Hi, I wanted to find out if there is a way to get column headers in the results for the queries. -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions.
    Ayon SinhaAyon Sinha
    Jul 21, 2011 at 7:58 pm
    Jul 21, 2011 at 9:07 pm
  • Hello! I am running hadoop on a red hat linux box on my native windows PC and I want to utilize HUE but I am not sure how to get the browser to work to use HUE. Any suggestions? -SB
    Sean BarrySean Barry
    Jul 20, 2011 at 3:50 pm
    Jul 21, 2011 at 9:52 am
  • Hi, I'm trying to run a query that will return the top 50 results within each group. The table contains millions of records and there are over 100 unique values in the field I wish to group by -- ...
    Vipul PatelVipul Patel
    Jul 12, 2011 at 1:27 am
    Jul 13, 2011 at 3:37 pm
  • Hello, When I execute multiple queries in Hive, the mapred tasks are queued up and executed one by one. Is there are way I could set Hive or Hadoop to execute mapred tasks in parallel? I am running ...
    Hadoop n00bHadoop n00b
    Jul 8, 2011 at 5:45 am
    Jul 8, 2011 at 1:34 pm
  • I'm new to hive and I'm having an issue loading a simple set of data via regex. I have a data file called test.txt that contains the following: TESTONE-1 TESTTWO-2 TESTTHREE-3 TESTFOUR-4 TESTFIVE-5 I ...
    Sal ScalisiSal Scalisi
    Jul 1, 2011 at 10:52 pm
    Jul 1, 2011 at 11:25 pm
  • hello, we have 2 tables x and y. table x is 11GB on disk and has 23M rows. table y is 3GB on disk and has 28M rows. Both tables are stored as LZO compressed sequencefiles without bucketing. a normal ...
    Koert KuipersKoert Kuipers
    Jul 22, 2011 at 9:52 pm
    Jul 25, 2011 at 7:03 pm
  • when I run hive sql "select * from user_info" with hive-jdbc(HiveServer) ,exception occur below. but I run the command "desc user_info" with cli,it's ok,no exception happen if I restart the ...
    Hello WorldHello World
    Jul 22, 2011 at 2:55 pm
    Jul 24, 2011 at 4:40 pm
  • I can do select a.x, b.y from db1.table1 a join db2.table2 b on a.id=b.uid but I cannot do: desc db1.table1 This throws error: hive desc db1.table1; FAILED: Execution Error, return code 1 from ...
    Ayon SinhaAyon Sinha
    Jul 17, 2011 at 2:23 am
    Jul 18, 2011 at 9:45 pm
  • Hello All, I'm using CDH 3 and Hue 1.2 on RHEL5 64 bit with mysql db based metastore. I'm running into a issue where Hue is showing any app in the browser. After checking the log files, it looks like ...
    Sanjeev sagarSanjeev sagar
    Jul 12, 2011 at 12:28 am
    Jul 12, 2011 at 1:41 am
  • Hi all, I'm experiencing problems with using LEFT OUTER JOIN with partitioned tables. The following example works as expected: SELECT a.val1, b.val2 FROM a JOIN b ON a.val1 = b.val1 AND a.dt = ...
    Wouter de BieWouter de Bie
    Jul 8, 2011 at 11:32 am
    Jul 11, 2011 at 6:39 am
  • Hi, Could somebody point me to some wiki abt how to create a UDF In hive ? My problem is how to include hive code in my build path to import exec.UDAF. I downloaded hive code from cloudera's ...
    Mapred LearnMapred Learn
    Jul 10, 2011 at 1:54 am
    Jul 10, 2011 at 2:27 am
  • Can I partition by an existing field? I have a 10 GB file with a date field and an hour of day field. Can I load this file into a table, then insert-overwrite into another partitioned table that uses ...
    Travis PowellTravis Powell
    Jul 8, 2011 at 8:14 pm
    Jul 9, 2011 at 4:48 am
  • I was able to use Hive successfully a few weeks ago. When I tried again recently, I ran into issues and suspected that the problems may have been related to Hive's metastore. For better or worse, I ...
    Matthieu MartinMatthieu Martin
    Jul 1, 2011 at 1:03 am
    Jul 1, 2011 at 5:36 am
  • Hey , Is any1 using google snappy i tried it but didnt get success. If there any1 is using it please tell me the procedure to use it. -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 ...
    Vikas SrivastavaVikas Srivastava
    Jul 28, 2011 at 7:04 pm
    Jul 28, 2011 at 7:04 pm
  • Hi all, I tried to index the lzo file but got the following error while indexing the lzo file : java.lang.ClassCastException: com.hadoop.compression.lzo.LzopCodec$LzopDecompressor cannot be cast to ...
    Ankit JainAnkit Jain
    Jul 28, 2011 at 5:28 am
    Jul 28, 2011 at 5:28 am
  • https://cwiki.apache.org/confluence/display/Hive/ContributorsMinutes110726 If you were there and spot anything incorrect or left out, please let me know or edit the wiki. JVS
    John SichiJohn Sichi
    Jul 27, 2011 at 10:47 pm
    Jul 27, 2011 at 10:47 pm
  • With protobuf 2.4.1, Hive Serde throws an exception while inspecting the Objects Specifically it throws "java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for UNKNOWN" The ...
    Nagesh SusarlaNagesh Susarla
    Jul 27, 2011 at 8:29 pm
    Jul 27, 2011 at 8:29 pm
  • Hi, As I understand, currently Hive does not honor escaping delimiter characters for input format. So is the best choice for delimiters when the fields can have freeform text? Note that mysqldump ...
    Ayon SinhaAyon Sinha
    Jul 25, 2011 at 10:09 pm
    Jul 25, 2011 at 10:09 pm
  • Knowing that sequencefiles can store data (especially numeric data) much more compact that text, i started converting our hive database from lzo compressed text format to lzo compressed ...
    Koert KuipersKoert Kuipers
    Jul 25, 2011 at 7:54 pm
    Jul 25, 2011 at 7:54 pm
  • As the comments in HIVE-1228 mention, we decided not to address the :timestamp requirement. So if you need that, you can work on enhancing the HBase storage handler by opening a JIRA issue, proposing ...
    John SichiJohn Sichi
    Jul 25, 2011 at 7:26 pm
    Jul 25, 2011 at 7:26 pm
  • -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
    Vikas SrivastavaVikas Srivastava
    Jul 25, 2011 at 5:46 am
    Jul 25, 2011 at 5:46 am
  • I am reposting a message from friday to the Hive developer group to broaden the audience. Hopefully you won't mind the duplicate: Hello Hive users, I study informatics at the TU Berlin. As part of my ...
    Alexander AlexandrovAlexander Alexandrov
    Jul 24, 2011 at 9:52 pm
    Jul 24, 2011 at 9:52 pm
  • Hello, I switched to cdh3u0 recently from b3 and a daily hive job I used to run began failing with the stack trace below. I tailed all the logs while running it & didn't see anything unusual - it ...
    Ken barclayKen barclay
    Jul 21, 2011 at 3:10 pm
    Jul 21, 2011 at 3:10 pm
  • Hadoop Fans, It's my pleasure to announce the next monthly San Francisco Hadoop user group meetup. *When*: Wednesday, August 10, 2011 6:00 PM to 8:00 PM *Where*: USF Harney Science Center Golden Gate ...
    Aaron KimballAaron Kimball
    Jul 20, 2011 at 10:14 pm
    Jul 20, 2011 at 10:14 pm
  • Hey, Once hive generates the physical plan MapReduceTasks (as explained here<http://www.slideshare.net/nzhang/hive-anatomy ), I can see the produced tasks. However, I fail to understand their ID ...
    Ido HadannyIdo Hadanny
    Jul 20, 2011 at 1:34 pm
    Jul 20, 2011 at 1:34 pm
  • Hey, I'm trying to understand a hive explain-plan I generated and understand what's what. I couldn't find any documentation as this ...
    Ido HadannyIdo Hadanny
    Jul 20, 2011 at 1:10 pm
    Jul 20, 2011 at 1:10 pm
  • i am testing running a remote hive metastore. i understand that the client communicates with the metastore via thrift. now is it the case that the client still communicates with HDFS directly? in the ...
    Koert KuipersKoert Kuipers
    Jul 19, 2011 at 6:50 pm
    Jul 19, 2011 at 6:50 pm
  • What input format are you using in Hive? (It should be the one specified by the hive.input.format setting.) -----Original Message----- From: 牛兆捷 Sent: Sunday, July 17, 2011 10:26 PM To: ...
    Steven WongSteven Wong
    Jul 18, 2011 at 7:24 pm
    Jul 18, 2011 at 7:24 pm
  • Hey guys, is it possible, or are the plans of supporting, having a different serde at a partition level ? It would be useful to support data format changes. So when the serde is switched using ALTER ...
    Roberto CongiuRoberto Congiu
    Jul 18, 2011 at 6:15 pm
    Jul 18, 2011 at 6:15 pm
  • hey guys i'm seeing "Error: Java heapspace" msg quite often when running hive queries. i know one way to fix it is to up the jvm memory using this property: mapred.child.java.opts (currently our ...
    Shouguo LiShouguo Li
    Jul 15, 2011 at 2:57 am
    Jul 15, 2011 at 2:57 am
  • Hi, I have directories in HDFS that get populated by nightly ETL job on which we have Hive external tables. The problem we are having is that when the table schema changes such that there are new ...
    Ayon SinhaAyon Sinha
    Jul 13, 2011 at 11:10 pm
    Jul 13, 2011 at 11:10 pm
  • Is there any support for putting an encrypted password to my metastore db in hive-site.xml? Maybe an integration with jasypt? -- Frank Maritato
    Frank MaritatoFrank Maritato
    Jul 13, 2011 at 6:40 pm
    Jul 13, 2011 at 6:40 pm
Group Navigation
period‹ prev | Jul 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions56
posts152
users58
websitehive.apache.org

58 users for July 2011

Vikas Srivastava: 11 posts Koert Kuipers: 10 posts Ayon Sinha: 9 posts Wouter de Bie: 9 posts Guy Doulberg: 7 posts Edward Capriolo: 6 posts Steven Wong: 6 posts Yichuan (William) Hu: 5 posts Aniket Mokashi: 4 posts Labtrax: 4 posts Mayuresh: 4 posts Prashanth R: 4 posts Sal Scalisi: 4 posts Aggarwal, Vaibhav: 3 posts Ankit Jain: 3 posts Florin Diaconeasa: 3 posts Harsh J: 3 posts Carl Steinbach: 2 posts Hadoopman: 2 posts Hadoop n00b: 2 posts
show more
Archives