Search Discussions
-
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 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 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 shinde
Jul 25, 2012 at 8:46 am
Jul 26, 2012 at 8:44 pm -
10
Hive Query
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 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 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 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 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 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 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 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 ahamed
Jul 11, 2012 at 3:09 pm
Jul 12, 2012 at 11:44 am -
8
hi users
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 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 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 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 Kumar13
Jul 16, 2012 at 3:41 am
Jul 17, 2012 at 7:21 pm -
7
hi all
*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 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 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 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 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 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 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 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 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 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 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 ...
Abhishek
Jul 3, 2012 at 12:11 am
Jul 3, 2012 at 10:02 am -
Abhishek
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 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 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 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 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 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 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 ...
Abhishek
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 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, 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 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 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 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 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 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 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 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
Abhishek
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 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 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 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 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 Wang
Jul 9, 2012 at 11:14 pm
Jul 10, 2012 at 12:54 am
Group Overview
group | user |
categories | hive, hadoop |
discussions | 121 |
posts | 487 |
users | 94 |
website | hive.apache.org |
94 users for July 2012
Archives
- June 2016 (177)
- May 2016 (265)
- April 2016 (244)
- March 2016 (368)
- February 2016 (323)
- January 2016 (323)
- December 2015 (347)
- November 2015 (305)
- October 2015 (279)
- September 2015 (386)
- August 2015 (291)
- July 2015 (176)
- June 2015 (305)
- May 2015 (227)
- April 2015 (345)
- March 2015 (332)
- February 2015 (230)
- January 2015 (129)
- December 2014 (252)
- November 2014 (196)
- October 2014 (252)
- September 2014 (288)
- August 2014 (265)
- July 2014 (389)
- June 2014 (274)
- May 2014 (203)
- April 2014 (296)
- March 2014 (270)
- February 2014 (301)
- January 2014 (252)
- December 2013 (230)
- November 2013 (222)
- October 2013 (275)
- September 2013 (315)
- August 2013 (364)
- July 2013 (419)
- June 2013 (407)
- May 2013 (319)
- April 2013 (206)
- March 2013 (344)
- February 2013 (268)
- January 2013 (318)
- December 2012 (313)
- November 2012 (244)
- October 2012 (318)
- September 2012 (373)
- August 2012 (380)
- July 2012 (487)
- June 2012 (454)
- May 2012 (458)
- April 2012 (343)
- March 2012 (337)
- February 2012 (207)
- January 2012 (265)
- December 2011 (235)
- November 2011 (182)
- October 2011 (199)
- September 2011 (211)
- August 2011 (277)
- July 2011 (152)
- June 2011 (149)
- May 2011 (244)
- April 2011 (127)
- March 2011 (265)
- February 2011 (284)
- January 2011 (235)
- December 2010 (143)
- November 2010 (137)
- October 2010 (231)
- September 2010 (254)
- August 2010 (278)
- July 2010 (161)
- June 2010 (262)
- May 2010 (132)
- April 2010 (126)
- March 2010 (178)
- February 2010 (366)
- January 2010 (156)
- December 2009 (110)
- November 2009 (146)
- October 2009 (252)
- September 2009 (215)
- August 2009 (187)
- July 2009 (322)
- June 2009 (106)
- May 2009 (97)
- April 2009 (160)
- March 2009 (173)
- February 2009 (139)
- January 2009 (152)
- December 2008 (105)
- November 2008 (33)