Search Discussions
-
Hi, I am using hive from CDH4.2 in a fresh installation. I want to set a mysql metastore. When trying to connect to hive server using jdbc I am getting this error: Exception in thread "main" ...
Demian rosas
Apr 1, 2013 at 8:43 pm
Apr 3, 2013 at 8:20 pm -
Hi, I created 3 years of hourly log files (totally 26280 files), and use External Table with partition to query. I tried two partition methods. 1). Log files are stored as ...
Ian
Apr 4, 2013 at 11:01 pm
Jul 4, 2013 at 9:26 am -
I need rank() in Hive. I have't had much luck with Edward Capriolo's on git and it comes with no documentation. It depends on hive-test (also by Edward) and I can't get maven to build the tests for ...
Keith Wiley
Apr 1, 2013 at 10:46 pm
Apr 2, 2013 at 8:45 pm -
Hello, I have a table that is already created and is partitioned dynamically by day. i would like all future partitions to be bucketed on two columns. Can I add a bucket to a partitions in an already ...
Babe Ruth
Apr 30, 2013 at 7:04 pm
May 2, 2013 at 6:55 am -
Hi, I have an hbase cluster where I have a table with a composite key. I map this table to a Hive external table using which I insert/select data into/from this table: CREATE EXTERNAL TABLE event(key ...
Rupinder Singh
Apr 30, 2013 at 5:49 pm
May 2, 2013 at 1:40 am -
Hi all, Just started with an Hadoop / Hive POC to write a So far, I have installed: So far I have downloaded the Hadoop and Hive packages from: http://hadoop.apache.org/releases.html ...
Sebastien FLAESCH
Apr 26, 2013 at 11:32 am
Apr 30, 2013 at 3:50 pm -
Hi, I just found out, that I don't have to change the default file system of Hadoop. The location in the create table command has just to be changed: CREATE EXTERNAL TABLE testtable(nyseVal STRING, ...
Tim Bittersohl
Apr 18, 2013 at 1:44 pm
Apr 19, 2013 at 9:37 am -
Hi, I have a question regarding filters on timestamps. The syntax seems to be UNIX_TIMESTAMP('yyyy-MM-dd hh:mm:ss'), is there another way to express a datetime type? The problem is that I get an ...
LUTTER, Steffen
Apr 5, 2013 at 2:07 pm
Apr 11, 2013 at 3:22 pm -
Hi, My hadoop version is 0.20.203.0. And I also use Hive. The following is the exception I got. Exception in thread "main" java.lang.NoSuchFieldError: ALLOW_UNQUOTED_CONTROL_CHARS at ...
Hsuan-Yi Chu
Apr 10, 2013 at 2:20 am
Apr 10, 2013 at 7:58 am -
Hi I want to create a external hive table to a sequence file(each record - key value) on HDFS. How will the field names be mapped to the column names. Please Suggest. Thanks Ranjitha. ::DISCLAIMER: ...
Ranjitha Chandrashekar
Apr 4, 2013 at 5:44 am
Apr 5, 2013 at 10:12 am -
Hi all, I have two tables I need to join and then summarize. They are both huge (about 1B rows each, in the relevant partitions) and the query runs for over 2 hours creating 5T intermediate data. The ...
Gabi D
Apr 4, 2013 at 12:23 pm
Apr 27, 2013 at 6:14 pm -
Hey hive gurus - Is the "builtins" hive submodule in use? The submodule was added in HIVE-2523 as a location for builtin-UDFs, but it appears to not have taken off. Any objections to removing it? ...
Travis Crawford
Apr 4, 2013 at 9:02 pm
Apr 6, 2013 at 12:03 am -
Hi, I'm running hive job on 24TB dataset (on 34560 partitions ). here about 500 to 1000 mappers are getting succeded (total of 80000) and rest mappaers are taking for ever ( their status stays at 0% ...
Srinivas Surasani
Apr 25, 2013 at 9:34 pm
Apr 25, 2013 at 11:30 pm -
Hi Does anyone know the exact URL of the Hive IRC Channel. I try http://irc.freenode.net/#hive,and it does not works. Regards
YouPeng Yang
Apr 23, 2013 at 5:24 am
Apr 23, 2013 at 10:27 pm -
Hi, I am trying to set the property to change the logging interval to more than 5 seconds. Hence I am using the following parameter: jobclient.progress.monitor.poll.interval=5000 It works fine when I ...
Sumit ghosh
Apr 20, 2013 at 8:29 am
Apr 22, 2013 at 10:04 pm -
Hive users, I am having problems performing "complex" queries on Avro+Snappy data. If I do a "SELECT * FROM Blah LIMIT 50", I see the data coming back as it should be. But if I perform any kind of ...
Thomas, Matthew
Apr 7, 2013 at 9:41 pm
Apr 8, 2013 at 12:18 pm -
Hello, Does anyone know where can I download the Postgres schema script for Hive 0.10 ? Please let me know. Thanks!
Leena Gupta
Apr 30, 2013 at 6:53 pm
May 2, 2013 at 7:46 pm -
I am trying to query a huge file with 370 blocks, but it errors out with message of "number of mappers exceeds limit" and my cluster has a "mapred.tasktracker.map.tasks.maximum" set to 50. I have ...
Frank Luo
Apr 24, 2013 at 2:03 pm
Apr 24, 2013 at 5:25 pm -
Hi guys, I've created hive tables via 'hive -f' or hive interactive shell. Data are loaded to tables right after, so the tables are not empty. However, when I log out and log in to hive shell again, ...
Xun TANG
Apr 23, 2013 at 5:02 am
Apr 24, 2013 at 4:50 pm -
+1 . + <span class="m_body_email_addr" title="d98685a90d9543c52703799da3a2508b" user@hive.apache.org</span , may be this question is to hive users. even we are having issues with running python ...
Kishore Yellamraju
Apr 16, 2013 at 7:26 pm
Apr 24, 2013 at 12:16 am -
Hi hive users Sorry for missing the title on the previous mail. This is my first time to post a question here. I have gotten an exception when I count the rows of my hive table after I have loaded ...
YouPeng Yang
Apr 22, 2013 at 9:02 am
Apr 23, 2013 at 10:13 am -
partitioned_table is partitioned on year, month, day. A query of the form spins up zero mappers, one reducer, and returns NULL Hadoop job information for Stage-1: number of mappers: 0; number of ...
Robin Morris
Apr 18, 2013 at 8:15 pm
Apr 22, 2013 at 10:55 pm -
Hi It would be terrific to get some advice on migrating a schema from RDMS to Hive. Should the SQL schema for HIVE be identical to the SQL schema for a Posgresql/mysql database? Specifically: I have ...
Matthieu Labour
Apr 8, 2013 at 10:50 pm
Apr 9, 2013 at 9:01 pm -
Hello, I want to write a functionality using UDTF. The functionality involves reading 7 different text files and create lookup structures such as Map, Set, List , Map of String and List etc to be ...
Vivek thakre
Apr 3, 2013 at 8:36 pm
Apr 5, 2013 at 3:52 am -
Not sure what the issues is, conf is good, validated I can log in to mysql with username in the hive-site, and I ran the metastore update scripts. show tables; java.lang.OutOfMemoryError: Java heap ...
John Omernik
Apr 3, 2013 at 9:57 pm
Apr 4, 2013 at 1:20 am -
Hi I am using Hive-0.9.0 + Hadoop-2.0.1 with 2 machine. One machine contains say Machine-1 : NameNode, SecondaraNameNode , ResourceManager and Hive Machine-2 : Proxy server, JHS , DataNode and ...
Rohithsharma
Apr 8, 2013 at 10:40 am
May 28, 2013 at 8:11 am -
If I create a table that has a map<string, string field, will ORC files columnarize by the keys in the map? Or will all the pairs in the map be grouped together? My goal is to columnarize the storage ...
Sean McNamara
Apr 29, 2013 at 11:27 pm
May 3, 2013 at 9:30 pm -
Hey all, I am excited to announce availability of Apache Hive 0.11.0 Release Candidate 0 at: http://people.apache.org/~hashutosh/hive-0.11.0-rc0/ Maven artifacts are available here ...
Ashutosh Chauhan
Apr 30, 2013 at 5:42 am
Apr 30, 2013 at 7:35 am -
Hi Is it possible to create a Hive external table pointing to an HBase column family and for all versions of the data for the keys to be returned rather than just I presume the latest version of ...
Richard Payne
Apr 29, 2013 at 9:34 pm
Apr 30, 2013 at 12:37 am -
I would like permission to edit the Hive wiki, so I can fix problems I see as I find them. My Apache username is preece. Thanks, scott
Scott Preece
Apr 26, 2013 at 1:24 pm
Apr 29, 2013 at 8:45 am -
Hi hive users This is my first time to post a question here. I have gotten an exception when I count the rows of my hive table after I have loaded the data: hive create EXTERNAL TABLE ...
YouPeng Yang
Apr 22, 2013 at 8:59 am
Apr 22, 2013 at 9:16 am -
Hi, I have very generic question but I am looking to get some guidance from the community. I have a proprietary database system with SQL interface. But, we are exploring the opportunity to submit the ...
Ur lops
Apr 10, 2013 at 5:48 pm
Apr 10, 2013 at 6:09 pm -
Hi All, Recently we find that when multiple jdbc connection concurrently add jars, hiveserver will throw StackOverflowError when serializeMapRedWork to hdfs, I find the relate issue hive-2666 is ...
Wangwenli
Apr 8, 2013 at 12:28 pm
Apr 9, 2013 at 7:10 am -
Trying to make sure I understand this correctly. All databases and tables are stored in hive.metastore.warehouse.dir but the actual metadata for the database and tables (columns, types, partitions, ...
Mark
Apr 4, 2013 at 12:26 am
Apr 4, 2013 at 12:31 am -
Hi all, Just to let you know. The problem was that the metastore service was down. I was starting it with sudo service hive-metastore start and even when there was a message saying that the service ...
Demian rosas
Apr 3, 2013 at 9:22 pm
Apr 3, 2013 at 9:24 pm -
Hi, I am trying to do a hive run, every time towards the end of the run, over 90% of mapping (and only mapping),it will give this error. I did the same run before and it works fine. Does anyone know ...
Peter Chu
Apr 30, 2013 at 3:19 am
Apr 30, 2013 at 3:19 am -
I'm running hive-0.10.0 on hbase. I was able to map the hbase table and could run a few queries to check if the data is being mapped correctly. hive describe hive_hbase_data; OK id string from ...
Nishant Shobhit
Apr 26, 2013 at 11:44 am
Apr 26, 2013 at 11:44 am -
we apologize if you receive multiple copies of this message =================================================================== CALL FOR PAPERS 2013 Workshop on Middleware for HPC and Big Data ...
MHPC 2013
Apr 25, 2013 at 9:03 pm
Apr 25, 2013 at 9:03 pm -
Hi all, I have fallowing table. *Name(String) | Capacity(String) | Time(BIGINT)* * * I want to get rows which have 'Time' in last hour. How can I do that? I tried following but didn't work. *select * ...
Bhathiya Jayasekara
Apr 23, 2013 at 4:34 am
Apr 23, 2013 at 4:34 am -
Can any one help me to change this SQL to pig Latin SELECT ('CSS'||DB.DISTRICT_CODE||DB.BILLING_ACCOUNT_NO) BAC_KEY, CASE WHEN T1.TAC_142 IS NULL THEN 'N' ELSE T1.TAC_142 END TAC_142 FROM ( SELECT ...
Suneel hadoop
Apr 22, 2013 at 9:20 am
Apr 22, 2013 at 9:20 am -
We are looking into running multiple instances of HCatalog/WebHCat on different servers to achieve some sort of redundancy. From some tests it appears that multiple nodes seem to be synchronized ...
Nasron Cheong
Apr 18, 2013 at 5:41 pm
Apr 18, 2013 at 5:41 pm -
Hi all, I encounter a query hang issue when using RegexSerDe input data format is deliminated by @@@ there are 37 columns and 20 rows in this file. The execution steps are: 1. CREATE TABLE t1(var1 ...
Jbuy0710
Apr 18, 2013 at 11:30 am
Apr 18, 2013 at 11:30 am -
Hi, I do have an urgent problem with the Hive server in Java, reading data from Amazon S3. I try to read data from a table which content is stored on Amazon S3 space and process it with a local ...
Tim Bittersohl
Apr 18, 2013 at 10:47 am
Apr 18, 2013 at 10:47 am -
Hive is not filtering on the result of a UDF in the way I expect or desire it to. The example below shows a very small sample table. The nested query that follows the table dump attempts to filter ...
Keith Wiley
Apr 17, 2013 at 11:02 pm
Apr 17, 2013 at 11:02 pm -
Hi All, I am writing a java program to run concurrent JDBC statements. But it failed with: org.apache.thrift.TApplicationException: execute failed: out of sequence response The steps are: 1. open a ...
Bing Li
Apr 16, 2013 at 2:05 pm
Apr 16, 2013 at 2:05 pm -
Hi, I am trying to tune the performance of my cluster. The cluster is hosted on Amazon EMR. There are 2 separate clusters - 1 for HBase and 1 for Hive. Hive cluster has no persistent data, it ...
Rupinder Singh
Apr 12, 2013 at 5:50 am
Apr 12, 2013 at 5:50 am -
Hi all, I need to convert a string attribute that contains ints with occasional leading zeroes. Unfortunately, I can't simply cast() as Hive will try to parse those numbers as octals. Is a regex the ...
Igor Tatarinov
Apr 11, 2013 at 7:39 pm
Apr 11, 2013 at 7:39 pm -
Hi, Does anyone know, if hive can run a composite query over RCFILE and HBASE in the same query? Quick anwer will be highly appreciated Thanks in advance. Rob
Ur lops
Apr 10, 2013 at 10:06 pm
Apr 10, 2013 at 10:06 pm -
Hi How does hive interpret the complex datatpes (my own class) in the sequence file, say i have my own complex datatype (my own class) as the value written in the Sequence File. How do I make Hive ...
Ranjitha Chandrashekar
Apr 10, 2013 at 6:45 am
Apr 10, 2013 at 6:45 am
Group Overview
group | user |
categories | hive, hadoop |
discussions | 61 |
posts | 206 |
users | 77 |
website | hive.apache.org |
77 users for April 2013
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)