FAQ

Search Discussions

59 discussions - 235 posts

  • Hi, I'm one of engieer of sina.com. We have used hive ,hiveserver several months. We have our own tasks schedule system .The system can schedule tasks running with hiveserver by jdbc. But The ...
    王锋王锋
    Dec 12, 2011 at 1:44 am
    Dec 13, 2011 at 7:44 am
  • Hi, I am using Hive 0.7.1 on hadoop 0.20.205 While running hive. its giving me following error : Exception in thread "main" java.lang.NoSuchMethodError: ...
    Praveenesh kumarPraveenesh kumar
    Dec 30, 2011 at 9:40 am
    Jan 10, 2012 at 2:28 pm
  • Hi, Does Hive-Hbase integration require Hbase running in pseudo-distributed mode? I've build my Hadoop following this article ...
    Alok KumarAlok Kumar
    Dec 2, 2011 at 8:30 am
    Dec 3, 2011 at 7:32 am
  • Hi All, My setup is hadoop-0.20.203.0 hive-0.7.1 I am having a total of 5 node cluster: 4 data nodes, 1 namenode (it is also acting as secondary name node). On namenode I have setup hive with ...
    Savant, KeshavSavant, Keshav
    Dec 6, 2011 at 11:06 am
    Dec 8, 2011 at 10:31 am
  • Hi, I was wondering if there is a possibility in HIVE to handle nested JSON structures. I tried get_json_object and json_tuple but could not achieve any ...
    Ibrahim AcetIbrahim Acet
    Dec 9, 2011 at 9:05 am
    Jan 10, 2012 at 6:13 pm
  • Happy new year my friends.Happy birghday to you many many happy returns of the day have a great year ahead and Happy new year to you......may the coming year brings lods of love joy happyness and ...
    Shashwat shriparvShashwat shriparv
    Dec 31, 2011 at 8:44 pm
    Jan 3, 2012 at 6:30 am
  • fyi --- 11年12月14日,周三, Bing Li <lib_tj@yahoo.com.cn 写道: 发件人: Bing Li <lib_tj@yahoo.com.cn 主题: a potential bug in HIVE/HADOOP ? -- MetaStore, createDatabase() 收件人: "hive dev list" <dev@hive.apache.org ...
    Bing LiBing Li
    Dec 15, 2011 at 2:15 am
    Dec 17, 2011 at 5:02 pm
  • Hi, I'm experiencing the following: I've a file on s3 -- s3n://my.bucket/hive/ranjan_test. It's got fields (separated by \001) and records (separated by \n). I want it to be accessible on hive, the ...
    Ranjan BagchiRanjan Bagchi
    Dec 16, 2011 at 1:31 am
    Dec 16, 2011 at 8:53 pm
  • Hi,  I am new to Hive.  I am using Flume agent to collect log4j logs and sending to HDFS. Now i wanted to load the log4j format logs from HDFS to Hive tables. Each of the attributes in log ...
    Sangeetha kSangeetha k
    Dec 6, 2011 at 7:57 am
    Dec 7, 2011 at 3:47 am
  • Hi, I have simple hive select count(*) query,which results in the following exception. I am using Cloudera cdh3u1 ( hadoop/hbase/hive). However I am able to do "select * from t1" from hive CLI. Here ...
    jingjung Ngjingjung Ng
    Dec 16, 2011 at 8:00 am
    Dec 18, 2011 at 10:31 am
  • Hi, I have a Hbase table that I am able to insert data and do scan. I want to have use HIVE,. I was able to install HIVE and login to Hive Console. Can you please tell me the way I can access the ...
    Aditya KumarAditya Kumar
    Dec 13, 2011 at 5:30 am
    Dec 13, 2011 at 6:06 am
  • Hi, I am trying to create Hive tables on an EC2 instance. I get this strange error about URI schema and log4j properties not found. I do not know how to fix this. On EC2 instance : Ubuntu 10.04, ...
    Periya.DataPeriya.Data
    Dec 12, 2011 at 5:07 am
    Dec 13, 2011 at 2:30 am
  • Hi All, I have Unix timestamp in my table in UTC format. Is there is any inbuilt function to convert it into PST or PDT in YYYY-MM-DD HH:MM:SS format? I know there are functions like from_unixtime to ...
    Sonia gehlotSonia gehlot
    Dec 1, 2011 at 6:22 pm
    Dec 1, 2011 at 9:32 pm
  • when hiveserver is executing sql, it throws an exception: 2011-12-14 00:40:43,762 Stage-1 map = 90%, reduce = 13% 2011-12-14 00:40:45,771 Stage-1 map = 92%, reduce = 13% 2011-12-14 00:40:46,777 ...
    王锋王锋
    Dec 14, 2011 at 2:22 am
    Dec 23, 2011 at 2:48 am
  • Hi, I do have troubles setting up the Hive client for PHP using Thrift. I have searched the web for hours, but I have only found one tutorial about this topic. Unfortunately this tutorial seems to be ...
    Hive HadoopHive Hadoop
    Dec 19, 2011 at 5:05 pm
    Dec 19, 2011 at 6:12 pm
  • Hi all, I am trying to start hive server, but, after the command, it looks like nothing is happening. I am not even getting a prompt. Here are some details: - machine - EC2 Ubuntu 10.04 LTS - Hive ...
    Periya.DataPeriya.Data
    Dec 18, 2011 at 5:00 am
    Dec 18, 2011 at 7:00 pm
  • Hi list, I am trying to run a Join query on my 10 node cluster. My query looks as follows select * from A JOIN B on (A.a = B.b) size of A = 15 million rows size of B = 1 million rows The problem is ...
    John smithJohn smith
    Dec 5, 2011 at 9:38 pm
    Dec 11, 2011 at 9:54 pm
  • Hi, I want to know if there is any way to load data directly from some other DB, say Oracle/MySQL etc., into hive tables, without getting the data from DB into a text/rcfile/sequence file in a ...
    Aditya Singh30Aditya Singh30
    Dec 9, 2011 at 4:28 am
    Dec 9, 2011 at 8:47 am
  • Hi, I am running Hive 0.7.0 with Hadoop 0.20.2. I have one HDFS folder full of web server logs dated back several months. Is possible to partition an EXTERNAL TABLE without copying/moving files or ...
    Vince HoangVince Hoang
    Dec 8, 2011 at 8:47 pm
    Dec 9, 2011 at 2:17 am
  • Hi All, Is it possible to load data (in HDFS) using Hive Load data query from any of the Datanode? So that means can we insert files into datanode directly (or from hive installed on datanode) and ...
    Savant, KeshavSavant, Keshav
    Dec 8, 2011 at 7:24 am
    Dec 8, 2011 at 2:04 pm
  • Hi, I have a following smaple query: select A, CASE WHEN B IN(1,2) THEN 'Type A' ELSE 'Type B' END AS B, C from table_a groupby A, B, C; But when i run this query, it gives error: FAILED: Error in ...
    Mapred LearnMapred Learn
    Dec 4, 2011 at 9:22 am
    Dec 5, 2011 at 8:26 am
  • Hi everybody, I have a question about hbase hive integration that, I have not can found in any where: if I run a hive query, this query will read the HFiles from hdfs and run into my hadoop cluster, ...
    Gabriel EisbruchGabriel Eisbruch
    Dec 2, 2011 at 6:53 pm
    Dec 2, 2011 at 10:55 pm
  • Hi folks, Ok, I give you the context first : I have seen in the mailing list people advising the use of a ... LEFT OUTER JOIN ON ... followed by a WHERE close to write a NOT IN type of query. So to ...
    Mdefoinplatel ExtMdefoinplatel Ext
    Dec 22, 2011 at 1:29 pm
    Jan 3, 2012 at 7:53 am
  • The Apache Hive team is proud to announce the the release of Apache Hive version 0.8.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in ...
    Carl SteinbachCarl Steinbach
    Dec 19, 2011 at 6:30 pm
    Dec 21, 2011 at 10:03 am
  • Hello list, Could anyone tell me the basic (and must) requirements for integrating Hive and Hbase??? I have followed the " Hive HBase Integration " link on cwiki but I am not able to do it. Need some ...
    Mohammad TariqMohammad Tariq
    Dec 1, 2011 at 12:20 pm
    Dec 17, 2011 at 8:40 pm
  • Hello all, Is there any way to fetch the data from a table which is already present in Hbase using Hive directly??Or do I need to create the corresponding table in the Hive first?? Regards,   ...
    Mohammad TariqMohammad Tariq
    Dec 15, 2011 at 7:15 pm
    Dec 17, 2011 at 8:22 am
  • Hi, We want to get the job tracker Ids back in the code for logging purpose for the queries we fire using Hive Thrift client. We also want to get some stats that Hive displays on console like nnnnn ...
    Shantian PurkadShantian Purkad
    Dec 2, 2011 at 1:28 am
    Dec 16, 2011 at 4:54 am
  • Guys, I have been using hadoop for 3,4 months. Tried Map Reduce, HBase, Pig. Now wanted to learn HIVE. I hope it must be as exciting as other hadoop tools. Can someone suggest me some good tutorials, ...
    Praveenesh kumarPraveenesh kumar
    Dec 13, 2011 at 11:35 am
    Dec 13, 2011 at 4:00 pm
  • Hi, Can someone show me how to use RCfile in plain MapReduce job (as Input and Output Format)? Please.
    Dominik WiernickiDominik Wiernicki
    Dec 14, 2011 at 1:55 pm
    Jan 10, 2012 at 6:50 am
  • Hi all, is there a limitation in Hive to create a large number of columns, say a few million or so? If one is using MySQL for metastore, where would this limitation come from, if so? thanks,  ...
    Ameet chaubalAmeet chaubal
    Dec 20, 2011 at 7:09 pm
    Dec 22, 2011 at 8:55 pm
  • I just create a table fool; And table data is : sellerId consumerId 1000,4000 1000,4001 1002,4002 1003,4000 1004,4001 1005,4002 1000,4000 total 8 rows; then I execute sql "select consumerId from ...
    王锋王锋
    Dec 21, 2011 at 10:01 am
    Dec 22, 2011 at 1:31 am
  • Hi, I though that 'IN' clause was not supported by hive ( version 0.7 ) according to the documentation ...
    Rohan mongaRohan monga
    Dec 13, 2011 at 6:10 am
    Dec 13, 2011 at 6:09 pm
  • Hello list, I am trying to use Hbase and Hive together and I am able to create tables in Hbase using Hive..But while inserting I am facing the following error - INSERT OVERWRITE TABLE table1 SELECT * ...
    Mohammad TariqMohammad Tariq
    Dec 10, 2011 at 10:06 am
    Jan 18, 2012 at 1:10 pm
  • Hi, I am trying to run a simple query in my JDBC-Client java code: ============================================================= // create mon_tbl - Monthly aggregated data String mon_tblName = ...
    Periya.DataPeriya.Data
    Dec 23, 2011 at 5:10 pm
    Dec 26, 2011 at 6:13 pm
  • Hello All, One of my hive columns has text data in xml format. What are all the efficient ways to parse the xml and query based on certain node values. Biz User select/filter Query requirements are ...
    Ravikumar visweswaraRavikumar visweswara
    Dec 23, 2011 at 3:36 pm
    Dec 23, 2011 at 3:50 pm
  • Hey all, Marek Sapota has put together a doc on the new scripts for spreading Hive unit test execution across a cluster: https://cwiki.apache.org/confluence/display/Hive/Unit+Test+Parallel+Execution ...
    John SichiJohn Sichi
    Dec 15, 2011 at 9:19 pm
    Dec 16, 2011 at 1:48 am
  • Yo if you have patches outstanding, sorry about the conflicts from the massive one-time diff update from HIVE-1040 I just committed :) JVS
    John SichiJohn Sichi
    Dec 14, 2011 at 1:05 am
    Dec 14, 2011 at 2:45 am
  • Dear all , I am trying to process some web log data and one of the steps consists in parsing a string to extract the relevant fields. So I am using a FROM ... MAP... USING ... statement calling a ...
    Mdefoinplatel ExtMdefoinplatel Ext
    Dec 12, 2011 at 12:46 pm
    Dec 12, 2011 at 2:28 pm
  • Hello All, So I had a single node pseudo cluster that has been calculating me some statistics running for a year. finally it grew more than do-it-at-home task. So I have my data uploaded to s3, and I ...
    Cam BazzCam Bazz
    Dec 12, 2011 at 12:48 am
    Dec 12, 2011 at 2:43 am
  • Hi, I have a bunch of custom UDFs and I d like the others in the company to make use of then in an easy way . Im not very happy with the 'CREATE TEMPORARY FUNCTION' arrangement for each session . It ...
    Sam WilliamSam William
    Dec 8, 2011 at 8:20 pm
    Dec 8, 2011 at 8:35 pm
  • Hi,  I opened the web console for Hive using http://localhost:9999/hwi  In the Browse Schema option, I could see only the default Hive table list name and description. Not able to view the ...
    Sangeetha kSangeetha k
    Dec 6, 2011 at 2:51 pm
    Dec 6, 2011 at 3:10 pm
  • hive user -- Best wishs!
    曹坤曹坤
    Dec 30, 2011 at 2:03 am
    Dec 30, 2011 at 2:03 am
  • Hi all, I would really appreciate your thoughts and comments on this. I am using Hive 0.7.1 and Hadoop 0.20.203 on Amazon Elastic MapReduce. My .hiverc file looks like: add jar ...
    Mark GroverMark Grover
    Dec 23, 2011 at 6:59 pm
    Dec 23, 2011 at 6:59 pm
  • Hi, All When I ran hive UT, I found that TestHadoop20SAuthBridge wasn't compiled, so TestHadoop20SAuthBridge won't be run by "ant test" command. In src/shims/build.xml, I found the following lines: ...
    Bing LiBing Li
    Dec 22, 2011 at 8:16 am
    Dec 22, 2011 at 8:16 am
  • Hi, It looks like at one point there was an interest in supporting common table expressions in Hive. https://issues.apache.org/jira/browse/HIVE-1180 Is this still a planned feature?
    JcfolsomJcfolsom
    Dec 22, 2011 at 5:53 am
    Dec 22, 2011 at 5:53 am
  • Hello all, I have created a cluster on EC2 using Whirr-0.7.0 that has hadoop-0.20.2 and hbase-hbase-0.89.20100924..Now I am trying to use hbase through hive but I am facing some problems.whenever I ...
    Mohammad TariqMohammad Tariq
    Dec 22, 2011 at 3:06 am
    Dec 22, 2011 at 3:06 am
  • Hi all, I just found that before calling a "MAP ... FROM ... USING resource" command , the resource need first to be added to every machine in the cluster. Actually this makes perfect sense to me but ...
    Mdefoinplatel ExtMdefoinplatel Ext
    Dec 21, 2011 at 4:47 pm
    Dec 21, 2011 at 4:47 pm
  • ----------------------------------------------------------------------- shashwat shriparv wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or ...
    Shashwat shriparvShashwat shriparv
    Dec 16, 2011 at 7:52 am
    Dec 16, 2011 at 7:52 am
  • Hi, Devs When I ran Hive UT with the candidate build of Hive-0.8.0, I found that TestEmbeddedHiveMetaStore and TestRemoteHiveMetaStore always FAILED with ROOT account while PASS with NON-ROOT ...
    Bing LiBing Li
    Dec 15, 2011 at 3:13 pm
    Dec 15, 2011 at 3:13 pm
  • I saw a note in the DDL section about altering a table's properties. I can see some properties (called "parameters" in CLI output) with "describe extended <table_name " but wanted to be sure of what ...
    YpaiYpai
    Dec 14, 2011 at 9:55 pm
    Dec 14, 2011 at 9:55 pm
Group Navigation
period‹ prev | Dec 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions59
posts235
users68
websitehive.apache.org

68 users for December 2011

王锋: 27 posts Alo alt: 17 posts Mark Grover: 12 posts Mohammad Tariq: 10 posts Bejoy Ks: 9 posts John Sichi: 8 posts Aniket Mokashi: 7 posts Praveenesh kumar: 7 posts Raghunath, Ranjith: 7 posts Abhishek Pratap Singh: 6 posts Periya.Data: 6 posts Savant, Keshav: 5 posts Vivek Mishra: 5 posts Mdefoinplatel Ext: 4 posts Alok Kumar: 4 posts Sangeetha k: 4 posts Jcfolsom: 3 posts Aditya Kumar: 3 posts Ankit Jain: 3 posts Gabriel Eisbruch: 3 posts
show more
Archives