Grokbase Groups Hive user April 2013

Search Discussions

61 discussions - 206 posts

  • 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 rosasDemian 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 ...
    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 WileyKeith 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 RuthBabe 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 SinghRupinder 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: ...
    Sebastien FLAESCHSebastien 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 BittersohlTim 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, SteffenLUTTER, Steffen
    Apr 5, 2013 at 2:07 pm
    Apr 11, 2013 at 3:22 pm
  • Hi, My hadoop version is 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 ChuHsuan-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 ChandrashekarRanjitha 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 DGabi 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 CrawfordTravis 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 SurasaniSrinivas 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,and it does not works. Regards
    YouPeng YangYouPeng 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 ghoshSumit 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, MatthewThomas, 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 GuptaLeena 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 "" set to 50. I have ...
    Frank LuoFrank 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 TANGXun TANG
    Apr 23, 2013 at 5:02 am
    Apr 24, 2013 at 4:50 pm
  • +1 . + <span class="m_body_email_addr" title="d98685a90d9543c52703799da3a2508b"</span , may be this question is to hive users. even we are having issues with running python ...
    Kishore YellamrajuKishore 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 YangYouPeng 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 MorrisRobin 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 LabourMatthieu 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 thakreVivek 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 OmernikJohn 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 ...
    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 McNamaraSean 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: Maven artifacts are available here ...
    Ashutosh ChauhanAshutosh 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 PayneRichard 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 PreeceScott 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 YangYouPeng 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 lopsUr 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 ...
    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, ...
    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 rosasDemian 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 ChuPeter 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 ShobhitNishant 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 2013MHPC 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 JayasekaraBhathiya 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 hadoopSuneel hadoop
    Apr 22, 2013 at 9:20 am
    Apr 22, 2013 at 9:20 am
  • 麦树荣麦树荣
    Apr 22, 2013 at 8:58 am
    Apr 22, 2013 at 8:58 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 CheongNasron 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 ...
    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 BittersohlTim 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 WileyKeith 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 LiBing 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 SinghRupinder 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 TatarinovIgor 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 lopsUr 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 ChandrashekarRanjitha Chandrashekar
    Apr 10, 2013 at 6:45 am
    Apr 10, 2013 at 6:45 am
Group Navigation
period‹ prev | Apr 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop

77 users for April 2013

Sanjay Subramanian: 24 posts Demian rosas: 15 posts Keith Wiley: 11 posts Nitin Pawar: 9 posts Ranjitha Chandrashekar: 7 posts Sebastien FLAESCH: 7 posts Mark Grover: 6 posts Tim Bittersohl: 6 posts Yypvsxf19870706: 5 posts Edward Capriolo: 4 posts LUTTER, Steffen: 4 posts Ramki Palle: 4 posts Rupinder Singh: 4 posts Sumit ghosh: 4 posts Carl Steinbach: 3 posts Hsuan-Yi Chu: 3 posts Ian: 3 posts Igor Tatarinov: 3 posts Kulkarni Swarnim: 3 posts Mike Liddell: 3 posts
show more