FAQ

Search Discussions

69 discussions - 235 posts

  • Dear all, I am sorry I am posting this message again but I can't able to locate the root cause after googled a lot. I am trying Hive/Hbase Integration from the past 2 days. I am facing the below ...
    Adarsh SharmaAdarsh Sharma
    Jan 6, 2011 at 10:30 am
    Jan 12, 2011 at 7:06 am
  • hi, I've setup a single node hadoop and hive. And can create table in hive, but can't drop table, hive cli will hang there, nothing more infos. hive-0.6.0-bin hadoop-0.20.2 jre1.6.0_23 ...
    WdWd
    Jan 6, 2011 at 9:30 am
    Apr 28, 2011 at 7:41 am
  • Friendly greetings ! I am very frustrated about hive. i like the program but i find a problem avery day i try to use it and i can't find any support on irc. so here i am ! 1st problem : hive create ...
    Laurent LabordeLaurent Laborde
    Jan 27, 2011 at 3:50 pm
    Feb 2, 2011 at 12:04 am
  • Hi All, i set hive odbc wrapper using directions given in http://wiki.apache.org/hadoop/Hive/HiveODBC . When i test it with isql it says [ISQL]ERROR: Could not SQLConnect i have hive server started ...
    Vaibhav negiVaibhav negi
    Jan 5, 2011 at 7:45 am
    Jan 6, 2011 at 6:09 pm
  • I am trying to explore some use case that I believe are perfect for the columnarSerDe, tables with 100+ columns where only one or two are selected in a particular query. CREATE TABLE (....) ROW ...
    Edward CaprioloEdward Capriolo
    Jan 24, 2011 at 8:32 pm
    Jan 25, 2011 at 7:07 pm
  • Hey all, I am new to this hive thing, but I have a very complex task to perform, I am a little stuck. I hope someone here can help. My team has been storing data to a custom sequence file that has a ...
    Guy DoulbergGuy Doulberg
    Jan 16, 2011 at 7:59 pm
    Jan 17, 2011 at 3:33 pm
  • Hi there, I'am trying the jdbc example http://wiki.apache.org/hadoop/Hive/HiveClient#JDBC and getting that for the select count(1) query 11/01/03 12:34:35 INFO exec.MapRedTask: Generating plan file ...
    Malte EhmkeMalte Ehmke
    Jan 3, 2011 at 12:38 pm
    Jan 3, 2011 at 9:45 pm
  • Hi! I'm a graduate student from Georgia Tech and I'm working with Hive for a research project. I am interested in query optimization and the Hive MetaStore in that context. Working through the ...
    Anja GruenheidAnja Gruenheid
    Jan 31, 2011 at 10:05 pm
    Feb 1, 2011 at 8:43 am
  • Hi, I'm attempting to load a small to medium sized log file, ~250MB, and produce some basic reports from it, counts etc. Nothing fancy. However, whenever I try and read the entire dataset, ~330k ...
    Christopher, PatChristopher, Pat
    Jan 27, 2011 at 1:48 am
    Jan 28, 2011 at 6:34 am
  • I have a 10 node server or so, and have been mainly using pig on it, but would like to try out Hive. I am running this query, which doesn't take too long in Pig, but is taking quite a long time in ...
    Jonathan CoveneyJonathan Coveney
    Jan 24, 2011 at 9:14 pm
    Jan 25, 2011 at 3:46 pm
  • I am facing issues with a query where I am joining two fairly large tables on the partitioned column along with other common columns. The expected output is not in line with what I expect it to be. ...
    Viral BajariaViral Bajaria
    Jan 18, 2011 at 10:05 am
    Jan 20, 2011 at 12:45 am
  • Hello, My questions in short are: - why are sequencefiles bigger than textfiles (considering that they are binary)? - It looks like compression does not make for a smaller sequence file than the ...
    Ajo FodAjo Fod
    Jan 18, 2011 at 2:13 pm
    Jan 19, 2011 at 9:50 pm
  • Hi, While loading some 10k+ .gz files through HiveServer with LOAD FILE etc. etc. 11/01/06 22:12:42 INFO exec.CopyTask: Copying data from file:XXX.gz to hdfs://YYY 11/01/06 22:12:42 INFO ...
    Terje MarthinussenTerje Marthinussen
    Jan 7, 2011 at 12:58 am
    Jan 7, 2011 at 11:00 am
  • Dear all, I am trying Hive/Hbase Integration from the past 2 days. I am facing the below issue while creating external table in Hive. *Command-Line Error :- ...
    Adarsh SharmaAdarsh Sharma
    Jan 5, 2011 at 10:11 am
    Jan 6, 2011 at 4:29 am
  • Hi, I've written a SerDe and I'd like it to be able handle compressed data (gzip). Hadoop detects and decompresses on the fly so if you have a compressed data set and you don't need to perform any ...
    Christopher, PatChristopher, Pat
    Jan 28, 2011 at 6:59 pm
    Jan 28, 2011 at 11:00 pm
  • When I execute "create table tag16(auction int, tagid int, cost double, title string, description string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','" , the hive throw "AILED: Error in metadata: ...
    Lei liuLei liu
    Jan 28, 2011 at 10:32 am
    Jan 28, 2011 at 2:43 pm
  • Hi, we had been running cloudera distribution of hadoop. We installed hive following this document https://wiki.cloudera.com/display/DOC/Hive+Installation. hive-site.xml was later modified for ...
    Vipul sharmaVipul sharma
    Jan 20, 2011 at 12:05 am
    Jan 20, 2011 at 12:43 am
  • Hi all I create a table with a partition. Then I import data into this table without specify partition, in this case I cannot retrieval data from this table using select statement. But I can retrieve ...
    Jeff ZhangJeff Zhang
    Jan 7, 2011 at 8:50 am
    Jan 7, 2011 at 2:06 pm
  • Now there is thrift 0.5 version, dose hive0.6 use thrift 0.5 version? Thanks, LiuLei
    Lei liuLei liu
    Jan 5, 2011 at 6:55 am
    Jan 5, 2011 at 7:44 am
  • Hi, I am working on some large scale unique users analysis (think hundreds of millions of records per day). Since number of all records per month goes into many billions I am hoping that there may be ...
    Radek MaciaszekRadek Maciaszek
    Jan 14, 2011 at 11:15 am
    Sep 7, 2011 at 8:22 am
  • I generate HDFS file , then I load the file to one hive table. There are some colums are don't have value, I need to set these colums to NULL. I want to know what char represents NULL value in hive. ...
    Lei liuLei liu
    Jan 21, 2011 at 9:10 am
    Feb 10, 2011 at 4:17 pm
  • Hi All, Just wondering if someone can throw some light on the fact how are the column names and types are provided to Deserializer while creating table. @Override public void initialize(Configuration ...
    Ankit bhatnagarAnkit bhatnagar
    Jan 21, 2011 at 8:09 pm
    Jan 28, 2011 at 10:02 pm
  • Hi All, I am planning to join some csv files using hive. referring to the developer guide on wiki quotes are not supported. ------------------------------------------------------- Hive currently use ...
    Ankit bhatnagarAnkit bhatnagar
    Jan 10, 2011 at 8:44 pm
    Jan 28, 2011 at 12:56 am
  • Hi, How do I use the mapjoin hint in a query. Say, I have two tables t1 and t2 where t2 is the smaller table. Do I specify t2 in the mapjoin hint? select /*+ mapjoin(b)*/ * from t1 join t2 b on (a.id ...
    Hadoop n00bHadoop n00b
    Jan 20, 2011 at 7:01 am
    Jan 20, 2011 at 2:24 pm
  • I've 2 questions: 1) how to raise the number of reducers? 2) why are there only 2 bucket files per partition even though I specified 32 buckets? I've set the following and don't see an increase in ...
    Ajo FodAjo Fod
    Jan 19, 2011 at 3:49 pm
    Jan 19, 2011 at 6:34 pm
  • Hello, I'm looking for help with UDFs. I need a UDF to do something like this: SELECT parseCoordinates(latitude, longitude) AS lat, lng FROM foo; But I'm not sure how. I've implemented a UDF using ...
    Lars FranckeLars Francke
    Jan 13, 2011 at 6:12 pm
    Jan 14, 2011 at 1:27 pm
  • Hello, I understand there is no way to delete data stored in a table. like a `delete from table_name` in the hive language. All this is fine, because all the query results are inserted into another ...
    Cam BazzCam Bazz
    Jan 31, 2011 at 7:57 pm
    Jan 31, 2011 at 9:02 pm
  • Hello, I have written a problem in my previous email. I now tried: select item_view_raw.* from item_view_raw WHERE log_level = 'INFO'; and I get the same error. select * from item_view_raw works just ...
    Cam BazzCam Bazz
    Jan 31, 2011 at 2:29 pm
    Jan 31, 2011 at 7:18 pm
  • Hello, I like to do a reporting with Hive on something like tracking data. The raw data which is about 2 gigs or more a day I want to query with hive. This works already for me, no problem. Also I ...
    Hive1Hive1
    Jan 31, 2011 at 4:08 pm
    Jan 31, 2011 at 6:16 pm
  • https://issues.apache.org/jira/browse/HIVE-1293 : Is this JIRA truly fixed and included in 0.7.0? If so, can the patch be applied separately on top of 0.5.0 or 0.6.0? Are there instructions somewhere ...
    Jay RamadoraiJay Ramadorai
    Jan 26, 2011 at 6:53 pm
    Jan 26, 2011 at 7:52 pm
  • Hey, We made a query in hive, that calculates the number of distinct values in a group by. On small portion of data it worked well, however when we ran the query over large portion of data, we failed ...
    Guy DoulbergGuy Doulberg
    Jan 25, 2011 at 4:27 pm
    Jan 26, 2011 at 3:04 pm
  • Hi, I really like the virtual column feature in 0.7 that allows me to request INPUT__FILE__NAME and see the names of files that are being acted on. Because I can see the files that are being read, I ...
    Avram AelonyAvram Aelony
    Jan 24, 2011 at 10:59 pm
    Jan 24, 2011 at 11:12 pm
  • I don't think this works. ... it seems to fail on the if exists part. Is anyone's experience different ?... I'm using CDH3 ... Hive 0.5.0. -Ajo
    Ajo FodAjo Fod
    Jan 19, 2011 at 4:55 pm
    Jan 19, 2011 at 5:06 pm
  • Hi there. Just starting with Hive, and I have a question. Is there any way to load a batch script to Hive in order not to input each line separately? Ie. When I create the table I would like the ...
    ArdentoArdento
    Jan 11, 2011 at 11:04 pm
    Jan 12, 2011 at 1:26 am
  • Hi, While executing a query from hive ,a Job will get created. Please let me know the Mapping Between Hive Query And the Jobs that are created for that query. ?Is it One-One ? Thanks sandeep ...
    SandeepSandeep
    Jan 3, 2011 at 9:07 am
    Jan 3, 2011 at 9:43 am
  • Hello, After doing some aggregate counting, I now have data in a table like this: id count date_hour (this is a partition name) 1 3 2011310115 1 1 2011310116 2 1 2011310117 2 1 2011310118 and I need ...
    Cam BazzCam Bazz
    Jan 31, 2011 at 9:14 pm
    Feb 1, 2011 at 7:47 am
  • How can we preserve newlines in data in Hive columns? Currently newlines in data terminate the Hive record. I am using Sqoop to import data into Hive from external databases. Even using the the ...
    Jay RamadoraiJay Ramadorai
    Jan 27, 2011 at 7:27 pm
    Jan 28, 2011 at 12:19 am
  • Hi I'm in the process of setting up an init script for the hive metastore. Whats the proper way to shutdown the hive metastore without killing pid? Or is killing the pid the only way? ...
    Matias SilvaMatias Silva
    Jan 25, 2011 at 7:41 pm
    Jan 27, 2011 at 3:22 pm
  • When I use load data into table like this , LOAD DATA INPATH '/user/myname/kv2.txt' OVERWRITE INTO TABLE invites PARTITION (ds='2008-08-15'); The raw data /user/myname/kv2.txt was rename into hive`s ...
    母延年YNM母延年YNM
    Jan 26, 2011 at 8:14 am
    Jan 26, 2011 at 1:08 pm
  • Hi, We are exploring hive for a very large data warehouse (Up to 2 PB data size) and would like to get some information 1. What are your experiences on using hive for large data warehouses 2. What is ...
    Sheetal DolasSheetal Dolas
    Jan 25, 2011 at 7:50 pm
    Jan 25, 2011 at 10:41 pm
  • Hi, When I run hive queries, everything finishes successfully but in the jobtracker UI, I see a lot of failed/killed task attempts. For example I have a simple query that finishes in 4 minutes. On ...
    VijayVijay
    Jan 24, 2011 at 7:57 pm
    Jan 24, 2011 at 8:09 pm
  • Hey All again, I bet I am not the first one to ask this question, but I could not find an answer anywhere. I am using the following temporary function: CREATE TEMPORARY FUNCTION jeval AS ...
    Guy DoulbergGuy Doulberg
    Jan 19, 2011 at 7:40 am
    Jan 19, 2011 at 3:02 pm
  • Hello Hive-Team, just tried to build Hive from SVN under Windows and found a Problem. Quick an dirty Patch attached. bernd
    Bernd DutkowskiBernd Dutkowski
    Jan 10, 2011 at 3:47 pm
    Jan 11, 2011 at 3:24 pm
  • Hi Jianhua, I think that all of the wiki attachments were removed in an effort to get rid of spam postings that had been flooding the wiki. I believe that the diagrams that originally appeared in the ...
    Carl SteinbachCarl Steinbach
    Jan 10, 2011 at 6:56 am
    Jan 10, 2011 at 7:35 am
  • Hi all, We've been running hive in the default derby single user mode for a while. Now we've got more users interested in Hive and so would like to change the metastore to run off of mysql. I was ...
    Chris BatesChris Bates
    Jan 5, 2011 at 10:32 pm
    Jan 6, 2011 at 6:48 pm
  • Hi there, I'am trying the jdbc example http://wiki.apache.org/hadoop/Hive/HiveClient#JDBC and getting that for the select count(1) query 11/01/03 12:34:35 INFO exec.MapRedTask: Generating plan file ...
    Malte EhmkeMalte Ehmke
    Jan 3, 2011 at 1:56 pm
    Jan 3, 2011 at 9:48 pm
  • Hi there, I'am trying the jdbc example http://wiki.apache.org/hadoop/Hive/HiveClient#JDBC Creating and inserting works. The problem is I don't see the created table witin the hive client and i can't ...
    Malte EhmkeMalte Ehmke
    Jan 3, 2011 at 12:43 pm
    Jan 3, 2011 at 2:18 pm
  • Hello, I just started hive today. Following instructions I did set it up, and made it work to play with my web server log files. I created two tables: CREATE TABLE item_view(view_time BIGINT, ...
    Cam BazzCam Bazz
    Jan 31, 2011 at 2:19 pm
    Jan 31, 2011 at 2:19 pm
  • Hi All, My hive jobs all finished successfully, output file created, hadoop job -list, displays no running jobs. I run hive -e '........' myfile. All Map/reduces are done and than I see 'OK' forever, ...
    Tali KTali K
    Jan 27, 2011 at 1:10 am
    Jan 27, 2011 at 1:10 am
  • I use hive 0.6 version, I use JDBC to execute one search sql, for example below code: public static void query() { Connection hiveConnection = null; Statement statement = null; try { ...
    Lei liuLei liu
    Jan 25, 2011 at 2:24 am
    Jan 25, 2011 at 2:24 am
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions69
posts235
users66
websitehive.apache.org

66 users for January 2011

Ajo Fod: 21 posts Edward Capriolo: 18 posts Adarsh Sharma: 16 posts Guy Doulberg: 9 posts Jean-Daniel Cryans: 9 posts Malte Ehmke: 9 posts Carl Steinbach: 8 posts Vaibhav negi: 8 posts John Sichi: 7 posts Viral Bajaria: 7 posts 김영우: 6 posts Cam Bazz: 6 posts Christopher, Pat: 6 posts Wd: 6 posts Namit Jain: 5 posts Phil young: 5 posts Yongqiang he: 5 posts Ankit bhatnagar: 4 posts Hadoop n00b: 4 posts Laurent Laborde: 4 posts
show more
Archives