FAQ

Search Discussions

93 discussions - 373 posts

  • Hi, I'm new to hive. As first step downloaded version 0.9 and upacked it. Set the HIVE_HOME to the unpacked folder. I already have hadoop 1.0.3 installed and its configuration is in classpath. Then ...
    SarathSarath
    Sep 17, 2012 at 10:54 am
    Sep 18, 2012 at 10:37 am
  • Hi, Here is the sample data "174969274","14-mar-2006"," 3522876","","14-mar-2006","500000308","65","1"| "174969275","19-jul-2006","3523154","","19-jul-2006","500000308","65","1"| ...
    Sandeep Reddy PSandeep Reddy P
    Sep 7, 2012 at 2:19 pm
    Sep 8, 2012 at 2:36 pm
  • Hivers, I want to understand that would it be possible to utilize zip/tar files directly into Hive. All the files has similar schema (structure). Say 50 *.txt files are zipped into a single zip file ...
    Manish.BhogeManish.Bhoge
    Sep 26, 2012 at 7:18 am
    Sep 27, 2012 at 11:12 am
  • Hi all, Is there any way to connect to hive server through API?? Regards Abhi Sent from my iPhone
    AbhishekAbhishek
    Sep 25, 2012 at 5:14 pm
    Sep 26, 2012 at 3:58 pm
  • Note: I am a newbie to Hive. Can someone please answer the following questions? 1) Does Hive provide APIs (like HBase does) that can be used to retrieve data from the tables in Hive from a Java ...
    Something SomethingSomething Something
    Sep 17, 2012 at 5:39 am
    Sep 18, 2012 at 4:37 am
  • Hi all, I have doubt regarding below properties, is it a good practice to override below properties in hive. If yes, what is the optimal values for the following properties? set ...
    AbhishekAbhishek
    Sep 26, 2012 at 12:37 pm
    Sep 26, 2012 at 6:05 pm
  • Hello Community, Is there any document/blog comparing different features offered by Pig 0.8 (0.9, 0.10) or greater and Hive 0.8 (0.9)? -Bharath
    Bharath MundlapudiBharath Mundlapudi
    Sep 14, 2012 at 5:34 pm
    Sep 21, 2012 at 2:37 am
  • Hi, I'm looking for a hive json serde that works well. Any suggestions? I did a quick google and found a few but none of them are complete. Thanks, Mark.
    Mark GoldenMark Golden
    Sep 17, 2012 at 6:56 pm
    Sep 18, 2012 at 9:15 pm
  • Hi all, I am trying to increase the performance of some queries in hive, all queries mostly contain left outer join , group by and conditional checks, union all. I have over riden some properities in ...
    AbhishekAbhishek
    Sep 27, 2012 at 1:33 pm
    Sep 28, 2012 at 8:46 pm
  • Hi All, I am learning hive. Please let me know if any one tried with custom Map Reduce scripts using java in hive or refer me some links and blogs with an example. when i tried i got the below ...
    Manu AManu A
    Sep 25, 2012 at 10:14 am
    Sep 26, 2012 at 9:44 am
  • I have a file whose content is: 1,1 2,1 3,2 4, 5, Then I import in into a hive table. create external table testtest (id int,value int) row format delimited fields terminated by ',' stored as ...
    MiaoMiaoMiaoMiao
    Sep 5, 2012 at 4:24 am
    Sep 6, 2012 at 4:11 am
  • Hi all, I have a table called ABC, like name grp A 1 B 2 C 4 D 8 I want the output like the name having greatest grp i.e D; I wrote a query: select name from ( select MAX(grp) from ABC ) gy ; but it ...
    Yogesh dhariYogesh dhari
    Sep 27, 2012 at 7:29 pm
    Sep 27, 2012 at 9:55 pm
  • Hi all, I am trying to run hive wi but its showing FATAL, I have used this command hive --service hwi but it shows.. yogesh@yogesh-Aspire-5738:/opt/hive-0.8.1/lib$ hive --service hwi 12/09/20 ...
    Yogesh dhariYogesh dhari
    Sep 19, 2012 at 9:46 pm
    Sep 19, 2012 at 10:32 pm
  • Hi, I am trying to get hive working on top of my hbase table following the guide below: https://cwiki.apache.org/Hive/hbaseintegration.html CREATE EXTERNAL TABLE hive_hbase_test (key string, a ...
    Shengjie MinShengjie Min
    Sep 11, 2012 at 1:41 pm
    Sep 12, 2012 at 9:33 pm
  • Hi all, my hive-site.xml is <property <name javax.jdo.option.ConnectionURL</name <value jdbc:mysql://127.0.0.1:3306/try?createDatabaseIfNotExist=true</value </property <property <name ...
    Yogesh dhariYogesh dhari
    Sep 9, 2012 at 8:52 am
    Sep 11, 2012 at 10:01 am
  • Hi all, I ran a query on hive on top of 90 million records that took 12 minutes to execute and same query on sql server took 8 minutes.My question is how can i make hadoop's performance better.What ...
    Iwannaplay gamesIwannaplay games
    Sep 5, 2012 at 6:19 am
    Sep 7, 2012 at 10:22 am
  • How does "collection items terminated by" work on a nested structure? Say the table is created with the DDL: CREATE TABLE table_1(f1 int, f2 string, f3 array <struct <a string, b int, c map<string, ...
    Sadananda HegdeSadananda Hegde
    Sep 28, 2012 at 5:01 am
    Oct 1, 2012 at 7:27 pm
  • Hi I am a new user of Hive, I am on version 0.9.0. I try to use hive web interface and I have this error : 12/09/27 11:05:02 INFO hwi.HWIServer: HWI is starting up 12/09/27 11:05:02 INFO ...
    Germain TanguyGermain Tanguy
    Sep 27, 2012 at 6:39 pm
    Sep 29, 2012 at 1:51 pm
  • Hi all, I built hive trunk and tried to debug the hive code. But when I start hive using this command ./hive --debug[port=8000,mainSuspend=y,childSuspend=y] It gives following error, ERROR: Cannot ...
    Kasun WerangaKasun Weranga
    Sep 22, 2012 at 3:29 pm
    Sep 24, 2012 at 11:54 am
  • Hivers, I have a web log which i need to load into single table. But one column has complete string of important data. However i want to extract complete information from 1 column and do further ...
    ManishManish
    Sep 21, 2012 at 4:34 am
    Sep 21, 2012 at 3:31 pm
  • Hi there, We're working on some queries that use buckets to improve performance with like 1000x. However we ran into a problem. When we use a fixed hardcoded date it works fine: SELECT * FROM ...
    Robin VerlangenRobin Verlangen
    Sep 20, 2012 at 11:36 am
    Sep 21, 2012 at 12:44 pm
  • I have created custom input format in java. Now I want to use that input format when creating table in Hive. Here are my steps: 1. Created jar file of the program. 2. Copied jar in /usr/lib/hadoop ...
    ManishManish
    Sep 20, 2012 at 3:10 pm
    Sep 20, 2012 at 3:42 pm
  • Hello , When I want to make connection with hive I got the following warning message. [hadoop@NHCLT-PC44-2 conf]$ hive WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use ...
    Ajit Kumar ShreevastavaAjit Kumar Shreevastava
    Sep 17, 2012 at 10:42 am
    Sep 20, 2012 at 1:33 pm
  • Does anyone know if insert into statement is supposed to work across databases/schemas? For instance if I do this the target table gets appended correctly: insert into table target select * from ...
    Kaufman NgKaufman Ng
    Sep 13, 2012 at 8:36 pm
    Sep 18, 2012 at 10:42 pm
  • Hi, I would like to seek help on loading logfiles to hive tables. I learnt from the "Getting Started" page that we could create hive tables as follow to import apachelog into it ...
    Elaine GanElaine Gan
    Sep 4, 2012 at 5:08 am
    Sep 5, 2012 at 2:02 am
  • Hi I tried to convert and merge many small text files using RCFiles using hivesql,but hive produced some small rcfiles. set hive.exec.compress.output=true; set mapred.output.compress=true; set ...
    王锋王锋
    Sep 19, 2012 at 2:26 pm
    Sep 28, 2012 at 12:37 pm
  • Hi all, I have a file in which records are Tab-Seprated, Please suggest me how to upload such file in Hive table. Like how to specify Create table XYZ (name STRING, roll INT) ROW FORMAT DELIMITED ...
    Yogesh dhariYogesh dhari
    Sep 27, 2012 at 5:12 am
    Sep 28, 2012 at 2:19 am
  • Hi, When I run the query "select count(1) from table1;" it fails with the exception message as below. /java.io.FileNotFoundException: File does not exist ...
    SarathSarath
    Sep 25, 2012 at 10:18 am
    Sep 27, 2012 at 6:03 am
  • Hi all, I have written a query with group by clause, it is consuming lot of time is there any way to optimize this any configuration property or some thing. Regards Abhi Sent from my iPhone
    AbhishekAbhishek
    Sep 26, 2012 at 5:01 pm
    Sep 26, 2012 at 5:58 pm
  • I am really struggling trying to make hears or tails out of how to optimize the data in my tables for best query times. I have a partition that is compressed (Gzip) RCFile data in two files total ...
    John OmernikJohn Omernik
    Sep 25, 2012 at 6:57 pm
    Sep 26, 2012 at 2:33 pm
  • Hi, All I have am writing a Hive client to run a Hive query using Hive JDBC driver. Since the data amount is huge I really would like to see the progress when the query is running. Is there anyway I ...
    Haijia ZhouHaijia Zhou
    Sep 14, 2012 at 7:18 pm
    Sep 17, 2012 at 1:24 pm
  • Hi, I am trying to write a hive script which is doing some summarization. There are two summarizations hourly and daily. I want to run the hourly summarization first, then check whether the current ...
    Amila Maha ArachchiAmila Maha Arachchi
    Sep 13, 2012 at 11:50 am
    Sep 14, 2012 at 4:45 am
  • I have 3 tables, each contains monthly data, I would like to make a table to concatenate all 3 months into 1 table. What is the most efficient way to do that? I am using insert into which takes a ...
    Zuohua zhangZuohua zhang
    Sep 12, 2012 at 8:03 pm
    Sep 13, 2012 at 1:26 am
  • I have a table, containing userId and userType. userId userType 1 A 2 B 3 C 4 A 5 B 6 B I want to get percentage of each userType. My current solution: 1. Get count of each group via THRIFT select ...
    MiaoMiaoMiaoMiao
    Sep 7, 2012 at 5:24 am
    Sep 7, 2012 at 7:12 am
  • I'm going through the tutorial at https://cwiki.apache.org/Hive/tutorial.html . It's not clear to me what the exact format of the log file would be for the sample queries described eg at ...
    David SwearingenDavid Swearingen
    Sep 1, 2012 at 11:52 am
    Sep 1, 2012 at 3:47 pm
  • Hi all, I have use case where we are doing Cartesian product of two tables with One table with 990k rows Second table 20k rows Query is Cartesian product of just two columns. So it comes around 20 ...
    AbhishekAbhishek
    Sep 29, 2012 at 3:56 am
    Oct 1, 2012 at 4:02 am
  • Hi, I have created a new table using reference to a file on HDFS - /create external table table1 (field1 STRING, field2 STRING, field3 STRING, field3 STRING, field4 STRING, field5 FLOAT, field6 ...
    SarathSarath
    Sep 28, 2012 at 5:58 am
    Sep 28, 2012 at 10:03 am
  • Using hive server with Tableau now and realize that the user comes in as "hive" user. Also after reading more in the emails and elsewhere and found that hive server is not thread safe and does not ...
    Chalcy RajaChalcy Raja
    Sep 26, 2012 at 3:56 pm
    Sep 27, 2012 at 10:49 am
  • Hi, Can anybody help me in following issues. 1) I am using hadoop-1.0.3 with hive-0.9.0 When start hive in embedded derby mode it is working fine. But when I start in external derby mode I am getting ...
    AnilKumar BAnilKumar B
    Sep 27, 2012 at 3:45 am
    Sep 27, 2012 at 10:25 am
  • Hi, I am using Cloudera release cdh3u3, which has the hive 0.71 version. I am trying to write a hive UDF function as to calculate the moving sum. Right now, I am having trouble to get the constrant ...
    Java8964 java8964Java8964 java8964
    Sep 25, 2012 at 7:17 pm
    Sep 26, 2012 at 9:08 pm
  • Hi all, I have enabled automatic Map join for any table less than 50MB. This table needs a custom serde, which is added every time using add Jars(size of jar is 25KB) in hive. The problem is when ...
    Abhishek Pratap SinghAbhishek Pratap Singh
    Sep 24, 2012 at 11:31 pm
    Sep 25, 2012 at 4:52 am
  • Hi folks, I want to provide the output of a select query to a where clause of another query as shown below. select * from TableA where TA_timestamp (select timestmp from TableB where id="hourDim") Is ...
    Amila Maha ArachchiAmila Maha Arachchi
    Sep 17, 2012 at 7:33 am
    Sep 17, 2012 at 8:54 am
  • Hi Everyone, I am running a join query on two tables in hive. When I run the join query, hive runs a map-reduce job.I can't seem to find the results of the join query. Can someone tell me where hive ...
    Rajesh BawalRajesh Bawal
    Sep 10, 2012 at 4:24 am
    Sep 10, 2012 at 2:15 pm
  • I am trying to insert data into a table after selecting and sorting by a column. What I really want is order by a column and select the top million rows. I am using Amazon EMR hive cloud to process ...
    Binesh GummadiBinesh Gummadi
    Sep 2, 2012 at 5:54 pm
    Sep 4, 2012 at 6:56 pm
  • Hi In Map-Reduce, is it appropriate to write the output directly to HDFS from Mapper (without using a reducer) ? Are there any adverse effects in doing so or are there any best practices to be ...
    Balaraman, AnandBalaraman, Anand
    Sep 28, 2012 at 4:15 am
    Sep 28, 2012 at 4:45 am
  • Pokarna, SameerPokarna, Sameer
    Sep 9, 2012 at 3:37 pm
    Sep 27, 2012 at 9:17 am
  • Hi, We have datasets which are about 10-15 TB in size. We want to run hive queries on top of this input data. What are ways to reduce stress on our cluster for running many such big queries( include ...
    Mapred LearnMapred Learn
    Sep 21, 2012 at 2:30 am
    Sep 21, 2012 at 6:07 am
  • Hi, We could not overwrite a file inside hive table folder. What is the command to over write it. Regards, Rams
    RamasubramanianRamasubramanian
    Sep 15, 2012 at 4:18 pm
    Sep 17, 2012 at 9:33 pm
  • Hi there, We're trying to load in lots of data into Hive, however the import command fails: *WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use ...
    Robin VerlangenRobin Verlangen
    Sep 17, 2012 at 9:47 am
    Sep 17, 2012 at 2:31 pm
  • All, I looked in the Hive JIRA and saw nothing like what we are looking to implement so I am interesting in getting feedback as to whether there is any overlap in this and any other current efforts ...
    Matt GoekeMatt Goeke
    Sep 12, 2012 at 6:10 pm
    Sep 12, 2012 at 10:52 pm
Group Navigation
period‹ prev | Sep 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions93
posts373
users105
websitehive.apache.org

105 users for September 2012

Bejoy KS: 27 posts MiaoMiao: 24 posts Abhishek dodda: 23 posts Connell, Chuck: 19 posts Yogesh dhari: 14 posts Bertrand Dechoux: 12 posts Edward Capriolo: 12 posts Sarath Chandra: 11 posts Manish.Bhoge: 10 posts Ashok Samal: 8 posts Manish Bhoge: 7 posts Chen Song: 6 posts Robin Verlangen: 6 posts Ajit Kumar Shreevastava: 5 posts Amila Maha Arachchi: 5 posts Haijia Zhou: 5 posts John Omernik: 5 posts Mark Golden: 5 posts Ruslan Al-Fakikh: 5 posts Tamil A: 5 posts
show more
Archives