Search Discussions
-
I used hive ver 0.71 in Amazon elastic map reduce to insert data from a partitioned table to another partitioned table. But for some reason it is not updating all the data in the partition table. I ...
Deepak Subhramanian
Oct 28, 2011 at 12:32 pm
Dec 23, 2011 at 8:03 pm -
HI, I am trying to figure out what I am doing wrong with this query and the unusual error I am getting. Also suspicious is the reduce % going up and down. select trans.property_id, ...
Mark Kerzner
Oct 19, 2011 at 2:06 pm
Oct 19, 2011 at 9:56 pm -
Hi Iam new to HIVE, when trying to create a table getting below exception. FAILED: Error in metadata: java.lang.IllegalArgumentException: URI: does not have a scheme Regards Kiran.G
Kiranprasad
Oct 19, 2011 at 9:15 am
Oct 19, 2011 at 2:10 pm -
Hello, I'm having trouble installing and running UnixODBC for Hive. Can anyone help? I'm trying to follow the guide at https://cwiki.apache.org/confluence/display/Hive/HiveODBC but it's not very ...
Tony Burton
Oct 26, 2011 at 4:06 pm
Oct 28, 2011 at 4:40 pm -
Dear all, Anybody show me how to get latest hive source code? Thanks in advance. Trang.
Trang van anh
Oct 28, 2011 at 1:02 am
Oct 28, 2011 at 11:31 am -
HI all,HIVE runs too slowly when it is doing such things(see the log below), what's the problem? because I'm joining two large table?it runs pretty fast at first. when the job finishes 95%, it begins ...
Bangbig
Oct 21, 2011 at 9:24 am
Oct 24, 2011 at 7:04 am -
Hi Experts I'm intending to use hive dynamic partition approach on my current business use case. What I have in mind for the design is as follows. -Load my incoming data into a non partitioned hive ...
Bejoy Ks
Oct 3, 2011 at 2:02 pm
Oct 4, 2011 at 6:32 pm -
Hi, I am finding some inconsistent behavior related to Hive authorization, and I am wondering if it is a bug or something related to my setup. I have our "default" database set up to only allow ...
Sriram Krishnan
Oct 24, 2011 at 11:39 pm
Oct 25, 2011 at 5:53 am -
Hi all, I have created database test_db and grant all permission to user 'apache' on 'test_db' hive create database test_db hive grant all on database test_db to user apache. hive show grant user ...
Ankit Jain
Oct 20, 2011 at 12:50 pm
Oct 20, 2011 at 2:31 pm -
Hey all, Earlier this year, Facebook released a bunch of its code browsing/review tools as a new (and independent) open source project called Phabricator: http://phabricator.org/ We're currently ...
John Sichi
Oct 20, 2011 at 9:00 pm
Oct 31, 2011 at 9:34 pm -
Hello, any body could tell me how can I do to set the hdfs user and group in a LOAD sentence from the JDBC driver? I have tried with many diferents way but ever that I tried the user used by the hive ...
Gabriel Eisbruch
Oct 25, 2011 at 7:07 pm
Oct 27, 2011 at 5:16 pm -
Hi All, I have a use-case where I will be joining table1 with table2. These are external tables with data in S3. table2 has many partitions (say 10K) size being around 2GB and table1 has around 5-10 ...
Thulasi Ram Naidu Peddineni
Oct 20, 2011 at 8:10 pm
Oct 21, 2011 at 8:21 am -
Hi All, I want some read-only data to be available at the reducers / transform scripts. I am trying to use distributed cache to achieve this using the following steps: 1. add file ...
Mohit Gupta
Oct 19, 2011 at 8:13 am
Oct 20, 2011 at 7:03 am -
Hello, We have multiple terabytes of data (currently in gz format approx size 2GB per file). What is best way to load that data into Hadoop? We have seen that (especially when loaded using hive's ...
Shantian Purkad
Oct 31, 2011 at 11:34 pm
Nov 2, 2011 at 10:06 am -
Dear all , I using sqoop tool to import data from sql server (importing data is a View in SQL) to hdfs but i face following problem, i have imported successfully 11/10/24 16:55:54 INFO ...
Trang van anh
Oct 24, 2011 at 10:02 am
Oct 25, 2011 at 2:18 am -
Hi all, Thank you in advance for your help. I am using Hive Transform functionality to populate a table which has a column of Map<String, String type. Here is the syntax for the reduce part: INSERT ...
Mark Grover
Oct 17, 2011 at 10:02 pm
Oct 20, 2011 at 1:44 pm -
Setup: I have setup a Hadoop cluster of 3 machines on Amazon EC2. Hive is running on top of it. Problem: Tables created on Hive are not accessible after Amazon EC2 instances are restarted (in other ...
Agarwal, Ravindra \(ASG\)
Oct 11, 2011 at 2:35 pm
Oct 13, 2011 at 5:38 am -
Hello, I have a question regarding the execution of some queries on bucketed tables. I've created a compressed bucketed table using the following statement: create external table partRC (P_PARTKEY ...
Avrilia Floratou
Oct 10, 2011 at 1:44 am
Oct 10, 2011 at 5:38 am -
Hi, I have some transactional data, which has a few map elements, but one more complex - array of maps. Something like this CREATE EXTERNAL TABLE mytable ( log_timestamp string, price map ...
Mark Kerzner
Oct 5, 2011 at 10:34 pm
Oct 7, 2011 at 2:54 am -
Hi, The loading of data into hive table currently moves the data if the location is hdfs (NON LOCAL). Is there an option that would allow to copy the data instead ? thanks, Navin
Navin Gupta
Oct 5, 2011 at 6:30 pm
Oct 6, 2011 at 12:06 am -
Hi, Trying to get the Hive Web UI running, but it 404s. Everything seems to be configured correctly running: hive --service hwi 11/10/05 11:02:43 INFO hwi.HWIServer: HWI is starting up 11/10/05 ...
Jcfolsom
Oct 5, 2011 at 4:10 pm
Oct 5, 2011 at 9:28 pm -
Hey All, i have an issue like i got a table having single partition but in that partition say around 100 200mb files when i overwrite this into other table its make 100 files of 20 mb(compressed) ...
Vikas Srivastava
Oct 21, 2011 at 8:19 am
Nov 9, 2011 at 3:06 am -
Hello, Lately our user base has increased so the input files have increased considerably in size and number. One of our processing steps is doing a query of the form found at the end of the email. My ...
Florin Diaconeasa
Oct 31, 2011 at 1:37 pm
Nov 3, 2011 at 8:13 am -
I've been working with the hive regexp_extract(string subject, string pattern, int index) command. In the hive language manual, ...
Sunderlin, Mark
Oct 27, 2011 at 5:57 pm
Oct 27, 2011 at 6:19 pm -
Hi, I am trying to understand the exact code flow of how the percentile_approx function works.... What happens step by step. Is there some write up which would help understanding the architecture? I ...
Mayuresh
Oct 21, 2011 at 5:07 pm
Oct 22, 2011 at 3:12 am -
I have the need to do some cleanup on my hive warehouse from java, such as deleting tables (both in metastore and the files on hdfs) I found out how to do this using remote connection: ...
Koert Kuipers
Oct 19, 2011 at 9:19 pm
Oct 19, 2011 at 11:27 pm -
Hi, I think I've isolated my Hive GROUP BY problem to this question, In Hive, the GROUP BY needs to be strict. I mean hive select property_id["property_id"], log_timestamp from trans group by ...
Mark Kerzner
Oct 19, 2011 at 8:06 pm
Oct 19, 2011 at 9:46 pm -
Hi all, I have created the database test_db in hive using command 'create database test_db'. Then i have created the table test_db_tb inside the database test_db. Now , I want to access those table ...
Ankit Jain
Oct 17, 2011 at 7:36 am
Oct 19, 2011 at 11:56 am -
please help me out in following error, I encounter it on cygwin hive show tables FAILED: Hive Internal Error: java.lang.IllegalArgumentException(java.net.URISyntaxException: Relative path in absolute ...
Siddharth tiwari
Oct 5, 2011 at 8:08 pm
Oct 14, 2011 at 7:50 am -
Dear Experts, I have problem with building index table in hive, step by step : 1. i created table named pv_users (pageid int, age int ) that has around 31 minion rows. 2 create index table create ...
Trang van anh
Oct 11, 2011 at 9:06 am
Oct 14, 2011 at 2:09 am -
I'd like to set up the Hive metastore such that I'm running "hive --service hiveserver" which itself would use an embedded Derby database. Then my hive clients would connect to the remote metastore. ...
Matt Kennedy
Oct 10, 2011 at 4:17 pm
Oct 11, 2011 at 3:51 am -
Hi, expert, I see this clause in CREATE TABLE -- COLLECTION ITEMS TERMINATED BY How does it work? Does Hive create a new row for each collection item, repeating the other elements? If not, how does ...
Mark Kerzner
Oct 4, 2011 at 4:28 pm
Oct 5, 2011 at 12:46 am -
Hi, I am trying to parse an apache2 log using the 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'. I am able to load the tables using the script below but its showing up each of the 3 rows as null ...
Jonathan
Oct 1, 2011 at 3:53 am
Oct 1, 2011 at 4:19 am -
Hello, I have been trying to learn the Hive query compiler and I am wondering if there is a way to see the result of semantic analysis (query block tree) and non-optimized logical query plan. I know ...
Hiroyuki Yamada
Oct 19, 2011 at 12:54 pm
Dec 6, 2011 at 8:10 pm -
Hi, I have a mapred that ends with an IntSumReducer that produces a SequenceFile<TextFormat, IntWritable . I tried to create an external table over the sequence files with the following statement is ...
Laurent Vaills
Oct 26, 2011 at 8:15 pm
Oct 27, 2011 at 2:35 am -
Hello, I am trying to use Sqoop to import data into Hive, and am running the following command: sqoop import --connect 'jdbc:mysql://dbhost/dbname' --username xxuser --table xxtable --password ...
Joshua Braegger
Oct 25, 2011 at 2:49 am
Oct 25, 2011 at 8:47 pm -
Using a normal hive connection and authorization it seems to work for me: hive revoke all on database default from user koert; OK Time taken: 0.043 seconds hive create table tmp(x string); ...
Koert Kuipers
Oct 19, 2011 at 10:02 pm
Oct 19, 2011 at 10:58 pm -
Dear all, I am using HIVE 0.7.1 version that supports indexing table, let example i have hive table with following structure: 1. create table pv_user (pageid int, stirng age); 2. create index table: ...
Trang van anh
Oct 14, 2011 at 3:27 am
Oct 17, 2011 at 2:51 pm -
Is there any possibility to start the hive server with the hbase.master specified? I know to hive -hiveconf hbase.master=ubuntu3:60000 and hive --service hiveserver. but how to specify the ...
Liming liu
Oct 12, 2011 at 7:29 am
Oct 13, 2011 at 5:41 pm -
Please help me to find java sources for hive compiler generated map-reduce jobs, if it possible. Thanks The information contained in this communication may be CONFIDENTIAL and is intended only for ...
Yakubovich, Alexey
Oct 12, 2011 at 9:08 pm
Oct 13, 2011 at 6:22 am -
1
Indexing
Hi, I'd like to know what's the current status of indexing in hive. What I've found so far is that the user has to manually set the index table for each query. Sth like this: ...Avrilia Floratou
Oct 7, 2011 at 6:31 pm
Oct 10, 2011 at 10:36 pm -
Hi, Alter Table name doesn't seem to like database name prepended to it. Is there a workaround ? thanks, Navin
Navin Gupta
Oct 5, 2011 at 11:17 pm
Oct 5, 2011 at 11:19 pm -
Hi All In HIVE, I would like to write a UDF that accepts a sequence of parameters. Due to that the number of parameters is large and the particular function that I am writing is specific to a set of ...
Chen Song
Oct 31, 2011 at 4:15 pm
Oct 31, 2011 at 4:15 pm -
How can one integrate Hadoop counters into Hive? Thanks!
Jason Rutherglen
Oct 31, 2011 at 3:15 pm
Oct 31, 2011 at 3:15 pm -
When I distribute Hive to a NFS and execute a select command, it failed: hive SELECT a.foo FROM invites a;Total MapReduce jobs = 1Launching Job 1 out of 1Number of reduce tasks is set to 0 since ...
Bing Li
Oct 31, 2011 at 3:10 pm
Oct 31, 2011 at 3:10 pm -
Hello, I am trying to understand how hive compiles and opmizes HiveQL queries for future development. I would like to know how to replace a input table name in the compilation process. For example, ...
Hiroyuki Yamada
Oct 27, 2011 at 8:16 am
Oct 27, 2011 at 8:16 am -
Hi All, Hive stores all the data under /user/hive/warehouse (configurable) Each table has a directory under /user/hive/warehouse. Under each table directory, the data files are stored . There can be ...
Benoy Antony
Oct 26, 2011 at 6:11 pm
Oct 26, 2011 at 6:11 pm -
Hi, Guys I met an error which is similar like described in HIVE-1478, but not exactly the same when run auto_join21.q in TestCliDriver. Do you have some ideas on this? ============== Re-Produce ...
Bing Li
Oct 25, 2011 at 6:27 pm
Oct 25, 2011 at 6:27 pm -
Hi all, How we can Add user on group in hive?? I also go through the following sites: https://cwiki.apache.org/confluence/display/Hive/AuthDev but didn't get anything about "how we can add user on ...
Ankit Jain
Oct 24, 2011 at 1:32 pm
Oct 24, 2011 at 1:32 pm -
Hello [14:39] Running a job on AWS EMR, I got the following error: java.lang.ClassCastException: org.apache.hadoop.hive.serde2.lazy.objectinspector.LazyListObjectInspector cannot be cast to ...
Miguel Cabero
Oct 17, 2011 at 4:22 pm
Oct 17, 2011 at 4:22 pm
Group Overview
group | user |
categories | hive, hadoop |
discussions | 61 |
posts | 199 |
users | 66 |
website | hive.apache.org |
66 users for October 2011
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)