Grokbase › Groups › Hive › user › July 2012
FAQ

Hive > user > July 2012

Search Discussions

121 discussions - 487 posts

  • This is the below data in my Table1 BID PID TIME --------------+-------------------------+-------------------------------- 1345653 330760137950 2012-07-09 21:42:29 1345653 330760137950 2012-07-09 ...
    Comptech geekyComptech geeky
    Jul 19, 2012 at 8:00 pm
    Jul 19, 2012 at 11:10 pm
  • What's wrong with the below query. SELECT buyer_id, item_id, created_time FROM ( SELECT buyer_id, item_id, rank(buyer_id) as rank, created_time FROM testingtable1 DISTRIBUTE BY buyer_id, item_id SORT ...
    Raihan JamalRaihan Jamal
    Jul 10, 2012 at 5:40 am
    Jul 11, 2012 at 3:32 am
  • I am facing issue while executing HIVE queries on HBASE-HIVE integration. I followed the wiki hbase-hive integration https://cwiki.apache.org/Hive/hbaseintegration.html I have already passed all the ...
    Vijay shindeVijay shinde
    Jul 25, 2012 at 8:46 am
    Jul 26, 2012 at 8:44 pm
  • Hi all, I have two tables 1) sitealias 2) site sitealias contains ------------------------- id site_id ---------------------------- 1 15 2 12 3 12 4 15 --------------------------- site contains ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 24, 2012 at 7:15 am
    Jul 24, 2012 at 10:51 am
  • Hi I have created a table in Mysql by name Dummy and it has 2 columns, and 1 row of data I want to upload that table into Hive using Sqoop tool. I used this command sqoop import --connect ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 5, 2012 at 9:29 am
    Jul 5, 2012 at 2:02 pm
  • Hi All, even If if perform count(*) operation on table it shows error, select count(*) from dummysite; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 24, 2012 at 8:25 am
    Jul 24, 2012 at 12:45 pm
  • hi all, I am trying to install HIVE and HBASE Is there any dependency needs to be installed ? what versions of HIVE and HBASE are compatible? Is there any good document on configuring HIVE with HBASE ...
    abhiTowson calabhiTowson cal
    Jul 27, 2012 at 4:31 pm
    Jul 28, 2012 at 2:24 pm
  • Hi, Sorry this is an AWS Hive Specific question. I have two External Hive tables for my custom logs. 1. flat directory structure on AWS S3, no partition and files in bz2 compressed format (few big ...
    Richin JainRichin Jain
    Jul 24, 2012 at 3:34 am
    Jul 27, 2012 at 7:40 pm
  • Hi Is there any possibility of defining the output directory of a hive query using a Hive UDF? In my UDF, I am passing 2 parameters (as follows) and this generates a file-system URL *getFilePath( ...
    Manisha GayathriManisha Gayathri
    Jul 23, 2012 at 8:09 am
    Jul 23, 2012 at 10:05 am
  • Hello, The hive documentation states that either HADOOP_HOME should be set or hadoop should be on the path. However for some cases, where HADOOP_HOME was not set but hadoop was on path, I have seen ...
    Kulkarni SwarnimKulkarni Swarnim
    Jul 18, 2012 at 4:31 pm
    Jul 18, 2012 at 6:12 pm
  • Thanks for the reply guys, I have tried using the below cmd usr/local/hive-0.9.0# load data local inpath ‘/usr/local/hadoop_dir/hadoop/big_data/vender_details.txt’ into table vender; in the above ...
    Shaik ahamedShaik ahamed
    Jul 11, 2012 at 3:09 pm
    Jul 12, 2012 at 11:44 am
  • Hi All, Im not able to fetch the data from the hive table ,getting the below error FAILED: Error in semantic analysis: hive select * from vender; OK Failed with exception ...
    Shaik ahamedShaik ahamed
    Jul 5, 2012 at 6:48 am
    Jul 5, 2012 at 7:08 am
  • Hi I am trying to load a CSV file into HIve table. Everything works fine but when a fire "select * from tablename" command. It does not retun anything. --Create Table CREATE TABLE IF NOT EXISTS ...
    Kuldeep ChitrakarKuldeep Chitrakar
    Jul 30, 2012 at 11:56 am
    Jul 30, 2012 at 1:23 pm
  • Whenever I run the below query- * * *SELECT buyer_id, item_id, ranknew(buyer_id, item_id), created_time* *FROM (* * SELECT buyer_id, item_id, created_time* * FROM testingtable1* * DISTRIBUTE BY ...
    Raihan JamalRaihan Jamal
    Jul 20, 2012 at 7:13 pm
    Jul 20, 2012 at 10:45 pm
  • Hi all, I have data of Flat files, Log files, Images and .xls Files of around many G.B I need to put operation like searching, Querying over that raw data. and generating reports. And its impossible ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 16, 2012 at 3:41 am
    Jul 17, 2012 at 7:21 pm
  • *Hi users,* ** * As im selecting the distinct column from the vender Hive table * ** *Im getting the below error plz help me in this* ** *hive select distinct supplier from vender_sample;* Total ...
    Shaik ahamedShaik ahamed
    Jul 6, 2012 at 11:39 am
    Jul 11, 2012 at 2:48 pm
  • I wrote this query but everytime I get the below error. select * from (select t2.buyer_id, t2.item_id, t2.created_time as created_time, subq.user_id, subq.product_id, subq.timestamps as timestamps ...
    Raihan JamalRaihan Jamal
    Jul 9, 2012 at 6:42 pm
    Jul 10, 2012 at 9:46 pm
  • When I run this query, SELECT TOP 10 FROM TestingTable1 WHERE ORDER BY buyer_id, created_time DESC; I always get error as- *FAILED: Parse Error: line 1:7 cannot recognize input 'TOP' in select ...
    Raihan JamalRaihan Jamal
    Jul 10, 2012 at 2:31 am
    Jul 10, 2012 at 7:24 am
  • Hi Users, I have created dim_date table like below. table created successfully and i then load the data into the dim_date table while i am selecting the table, getting null values.my input file is ...
    Prabhu kPrabhu k
    Jul 25, 2012 at 10:36 am
    Jul 25, 2012 at 1:56 pm
  • Hi, Let's say logs are stored inside hdfs using the following file tree /<logtype /<month /<day . So for apache, that would be : /apache/01/01 /apache/01/02 ... /apache/02/01 ... I would like to know ...
    Bertrand DechouxBertrand Dechoux
    Jul 24, 2012 at 3:45 pm
    Jul 25, 2012 at 11:28 am
  • Hi All, I am looking for the report generating tool over Apache Hadoop-hive, Please suggest me some of these tools which are easily compatible and better. I am using Hadoop-0.20.2 and hive-0.8.1 ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 23, 2012 at 11:32 am
    Jul 23, 2012 at 6:17 pm
  • I have one question related to the output from the HiveQL query. Suppose I did some HiveQL query and I will be getting some output back, so those result set are getting stored somewhere in HDFS? If ...
    Raihan JamalRaihan Jamal
    Jul 12, 2012 at 6:32 pm
    Jul 12, 2012 at 7:20 pm
  • Hi all, I have problem when using left join with hive 0.7.1. I have a query below: select a.pid, b.pid tab1 a left join tab2 b on (a.pid=b.pid or substr(a.pid,1,27)=b.pid); But hive don't support ...
    周彩钦周彩钦
    Jul 26, 2012 at 3:12 pm
    Jul 26, 2012 at 5:53 pm
  • Has anyone being using hive 0.9.0 release with the CDH4 GA release? I keep hitting this exception on its interaction with HBase. java.lang.NoSuchMethodError ...
    Kulkarni SwarnimKulkarni Swarnim
    Jul 13, 2012 at 7:39 pm
    Jul 18, 2012 at 1:57 pm
  • Hi all, I am trying to upload files from hdfs to hive table, file in hdfs are imported by sqoop tool from mysql having table structure ****************************************** no name result class ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 12, 2012 at 10:17 am
    Jul 12, 2012 at 11:35 am
  • Hi all, I am trying to upload the tables from RDBMS to hive through sqoop, hive imports successfully. but i didn't find any table in hive that imported table gets uploaded into hdfs idr ...
    Yogesh dhariYogesh dhari
    Jul 4, 2012 at 5:39 am
    Jul 4, 2012 at 2:04 pm
  • Hi all, Can I know, how to override a property of mapred-site.xml in Hive join query. Suppose for map reduce job we override using -D <property name=value , how to do it with in hive query. Regards ...
    AbhishekAbhishek
    Jul 3, 2012 at 12:11 am
    Jul 3, 2012 at 10:02 am
  • AbhishekAbhishek
    Jul 27, 2012 at 4:41 pm
    Jul 27, 2012 at 11:12 pm
  • Hey Team, We have huge tables in Mainframe DB2. Can some one tell if its possible to pull data from DB2 in Mainframe to hive and then use MapReduce to sort the data in hive and push it back to ...
    Siddharth TiwariSiddharth Tiwari
    Jul 26, 2012 at 6:33 pm
    Jul 27, 2012 at 1:37 am
  • I am happy to announce that the Apache Hive PMC has voted to add existing committer Ashutosh Chauhan as a new PMC member. Thanks Ashutosh for all of your work on the project! JVS
    John SichiJohn Sichi
    Jul 17, 2012 at 7:35 am
    Jul 23, 2012 at 4:13 pm
  • Hi users, As i would like to know the syntax or the cmd to know the buckets. For example for partitions as we will give the below cmd to know the partitions for a table *show partitions xyz ...
    Shaik ahamedShaik ahamed
    Jul 18, 2012 at 9:55 am
    Jul 18, 2012 at 2:16 pm
  • Hi all, I have installed hadoop and hive and its working well through terminal, I have also started HWI (http://localhost:9999/hwi) Now I want to run queries like displaying Hive's table data, is it ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 18, 2012 at 10:07 am
    Jul 18, 2012 at 10:49 am
  • Hi all :-), Iam trying to access Hive Web Interface but it fails. I have this changes in hive-site.xml ************************************************************************************************ ...
    Yogesh Kumar13Yogesh Kumar13
    Jul 17, 2012 at 12:37 pm
    Jul 18, 2012 at 7:00 am
  • Hi all, Besides "-hiveconf x=y", does Hive support specifying per-query configuration via a file? Thanks, Jie
    Jie LiJie Li
    Jul 7, 2012 at 11:32 pm
    Jul 9, 2012 at 5:18 am
  • Hi all, Will hive support INSERT INTO ? and It is nothing but, appending new data to the existing data.Can any one please tell me how does it happen and which version of hive supports this? Regards ...
    AbhishekAbhishek
    Jul 4, 2012 at 2:20 am
    Jul 6, 2012 at 3:36 am
  • *select id2, SUM(count2),SUM(coalesce(count1, 0)) as count1 * *from table2 * * left outer join table1 * * on id1=id2 * * group by id2 * * with rollup * Whenever I am trying to run the above query, I ...
    Techy TeckTechy Teck
    Jul 26, 2012 at 1:29 pm
    Jul 26, 2012 at 3:06 pm
  • I created a Hive table that consists of two files, names1.txt and names2.txt. The table works correctly and answers all queries etc. I want to REPLACE names2.txt with a modified version. I copied the ...
    Connell, ChuckConnell, Chuck
    Jul 25, 2012 at 3:22 pm
    Jul 25, 2012 at 5:02 pm
  • Hi, Here is my stand. Hive provides a dsl to easily explore data contained in hadoop with limited experience with java and MapReduce. And Hive Web Interface provides an easy exposition : users need ...
    Bertrand DechouxBertrand Dechoux
    Jul 25, 2012 at 3:25 pm
    Jul 25, 2012 at 4:47 pm
  • Hi, I have a use case in HBase + Hive Integration where HBase primary key is a composite key and the keys is separated by us with a custom delimiter. So basically it is Key = A~B~C. Now, I wanted to ...
    Ankit kinraAnkit kinra
    Jul 24, 2012 at 7:15 am
    Jul 25, 2012 at 3:52 am
  • Hi all, Some queries in hive are executing for too long.So i have overriden some parameters in hive, for some querys performance increased rapidly when i overriden this properities for some querys no ...
    abhiTowson calabhiTowson cal
    Jul 23, 2012 at 3:25 am
    Jul 24, 2012 at 12:48 pm
  • Hello, I kind of have a pretty basic question here. I am trying to read structs stored in HBase to be read by Hive. In what format should these structs be written so that they can be read? For ...
    Kulkarni SwarnimKulkarni Swarnim
    Jul 23, 2012 at 4:28 pm
    Jul 23, 2012 at 6:52 pm
  • Whenever I am running the below query SELECT TT.BUYER_ID , COUNT(*) FROM (SELECT testingtable1.buyer_id, testingtable1.item_id, testingtable1.created_time from (select user_id, prod_and_ts.product_id ...
    Techy TeckTechy Teck
    Jul 21, 2012 at 1:07 am
    Jul 23, 2012 at 2:02 am
  • I have a join query on which I am joining like this below. And it is working fine ON (table1.item = prod.product *AND* table1.buyer = prod.user *AND* UNIX_TIMESTAMP(table1.tt_time) = prod.timestamps) ...
    Techy TeckTechy Teck
    Jul 20, 2012 at 10:45 pm
    Jul 20, 2012 at 11:27 pm
  • Whenever I am typing Hive at the command prompt, I am getting the below exception. What does that mean? * * *$ bash* *bash-3.00$ hive* *Exception in thread "main" java.io.IOException: Disc quota ...
    Comptech geekyComptech geeky
    Jul 20, 2012 at 8:12 am
    Jul 20, 2012 at 4:44 pm
  • Apart from partitions and buckets how to improve of hive queries Regards Abhi Sent from my iPhone
    AbhishekAbhishek
    Jul 19, 2012 at 1:24 pm
    Jul 19, 2012 at 1:51 pm
  • This is the Timestamp *1338674299000* When I tried converting the above timestamp into the date only. I got this below result for date by using this syntax- ...
    Raihan JamalRaihan Jamal
    Jul 18, 2012 at 8:12 pm
    Jul 18, 2012 at 8:21 pm
  • I am new to Unix Shell Scripting world. I wanted to run a simple *HiveQL*query from the Unix Shell script and output the result in a .txt file and then send that .txt file as an attachment in an ...
    Raihan JamalRaihan Jamal
    Jul 18, 2012 at 5:29 am
    Jul 18, 2012 at 6:41 am
  • Hi everyone, I'd like to do $subject and was approaching it with the following query: select activityId, count(activityId), *find_in_set("CCC", collect_set(msgBody))* from ActivityStream group by ...
    Tharindu MathewTharindu Mathew
    Jul 16, 2012 at 8:57 pm
    Jul 17, 2012 at 1:02 pm
  • I have this below query, whenever I try to execute it, I always get error, which I am not able to understand. SELECT t1.buyer_id, t1.item_id, t1.created_time, t2.product_id, t2.timestamps FROM ...
    Raihan JamalRaihan Jamal
    Jul 11, 2012 at 3:31 am
    Jul 14, 2012 at 6:53 pm
  • Hi all, New to here. I have sequence files and I want to read in Hive, I did some search on the net. looks the way I need to do 1. Write new FileInputFormat so Hive can read both key and value. (ref ...
    Daning WangDaning Wang
    Jul 9, 2012 at 11:14 pm
    Jul 10, 2012 at 12:54 am
Jul 2012
123
Group Navigation
period‹ prev | Jul 2012 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions121
posts487
users94
websitehive.apache.org

94 users for July 2012

Bejoy KS: 51 posts Yogesh Kumar13: 40 posts Raihan Jamal: 39 posts Kulkarni Swarnim: 33 posts Techy Teck: 27 posts Nitin Pawar: 24 posts abhiTowson cal: 22 posts Shaik ahamed: 22 posts Edward Capriolo: 17 posts Bertrand Dechoux: 9 posts Vijay: 9 posts Connell, Chuck: 8 posts Mohammad Tariq: 8 posts Vinod Singh: 8 posts Jasper Knulst: 7 posts Igor Tatarinov: 6 posts Navis류승우: 6 posts VanHuy Pham: 6 posts Vijay shinde: 6 posts Kuldeep Chitrakar: 5 posts
show more
Archives