FAQ

Search Discussions

78 discussions - 318 posts

  • Hi, I'm trying to get HWI running and accessible from an Amazon Web Services EMR instance. I've hit a blocker early on though, and the documentation is less than illuminating. Can you share any ...
    Tony BurtonTony Burton
    Jan 18, 2013 at 3:54 pm
    Jan 21, 2013 at 4:37 pm
  • I am calling a vote on the following two measures. Measure 1: Amend Hive Bylaws to Define Submodules and Submodule Committers If this measure passes the Apache Hive Project Bylaws will be amended ...
    Carl SteinbachCarl Steinbach
    Jan 28, 2013 at 7:47 pm
    Jan 31, 2013 at 10:04 pm
  • Hi All, We are exploring HWI to be used in PROD environment for adhoc queries etc. Want to check out in the hive community that can somebody share there experience while using the HWI in prod or any ...
    Manish MalhotraManish Malhotra
    Jan 5, 2013 at 1:58 am
    Jan 7, 2013 at 2:39 am
  • Hi All, Am Newbie in apache hive. I have create a table and thats points to the HDFS Folder path and its takes 15 min to execute the simple "*select*" stmt, Can anyone suggest me for a best practices ...
    VenkatramananVenkatramanan
    Jan 17, 2013 at 6:39 am
    Jan 23, 2013 at 8:00 am
  • All, I want to automate jobs against Hive (using an external table with ever growing partitions), and I'm running into a few challenges: Concurrency - If I run Hive as a thrift server, I can only ...
    Tom BrownTom Brown
    Jan 10, 2013 at 10:04 pm
    Jan 11, 2013 at 10:58 pm
  • Hello, My hive table is partitioned by year, month and day. I have defined it as external table. The M/R job correctly loads the files into the daily subfolders. The hdfs files will be loaded to ...
    Sadananda HegdeSadananda Hegde
    Jan 29, 2013 at 4:06 am
    Jan 30, 2013 at 2:06 am
  • Hi folks, I want to use the stack function, described here : https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-BuiltinTableGeneratingFunctions%2528UDTF%2529 Hive asks me to ...
    Mathieu DesprieeMathieu Despriee
    Jan 10, 2013 at 8:40 am
    Jan 11, 2013 at 3:01 pm
  • Hi, I want to call hive in c# how can I do that ? I found hive ODBC driver but not getting any downloadables.Can anyone give proper link to download hive ODBC driver . Regards, Chhaya Vishwakarma The ...
    Chhaya VishwakarmaChhaya Vishwakarma
    Jan 25, 2013 at 4:18 am
    Jan 30, 2013 at 6:50 am
  • Hello, I have seen many posts on various sites and MLs, but didn't find a firm answer anywhere: is it possible yes or no to force a smaller split size than a block on the mappers, from the client ...
    David MorelDavid Morel
    Jan 25, 2013 at 6:16 am
    Jan 25, 2013 at 1:39 pm
  • The documentation links are broken on hive.apache.org for every release newer than 0.7.1. Has the documentation been moved elsewhere? Thanks, lauren
    Lauren BlauLauren Blau
    Jan 22, 2013 at 10:07 am
    Jan 28, 2013 at 11:11 am
  • hi there I have a problem with creating a hive table. no matter what field delimiter I used, I always got a tab space in the head of each line (a line is a record). something like this: \t f1 \001 f2 ...
    RichardRichard
    Jan 9, 2013 at 7:44 am
    Jan 14, 2013 at 3:56 pm
  • Hi, I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr). I'm experiencing a problem where DROP TABLE does not respect the IF EXISTS clause, so it still throws an error when the table doesn't ...
    Marc LimotteMarc Limotte
    Jan 31, 2013 at 6:43 pm
    Feb 1, 2013 at 4:55 pm
  • I am running a transform script that parses through a bunch of binary data. In 99% of the cases it runs, it runs fine, but on certain files I get a failure (as seen below). Funny thing is, I can run ...
    John OmernikJohn Omernik
    Jan 29, 2013 at 1:43 pm
    Jan 30, 2013 at 5:36 pm
  • Hi, I am running into an issue where ALTER TABLE CHANGE COLUMN does not seem to be working. I have a table with a column data type looking like array<struct<a:int, b:int and I am trying to it change ...
    Hardik doshiHardik doshi
    Jan 30, 2013 at 8:14 am
    Jan 30, 2013 at 7:37 pm
  • Hi all (and happy New Year!) Is it possible to build a perl Thrift client for HiveServer2 (from Cloudera's 4.1.x) ? I'm following the instructions found here ...
    David MorelDavid Morel
    Jan 3, 2013 at 11:16 pm
    Jan 28, 2013 at 10:27 pm
  • Hi everyone, I had to kill some queries that were taking forever, and it turns out they were doing cartesian products (missing ON clause on a JOIN). I wonder how I could see that in the EXPLAIN ...
    David MorelDavid Morel
    Jan 28, 2013 at 9:40 am
    Jan 28, 2013 at 5:17 pm
  • Hi, I have writen a custom serde and bundle it in a jar file, which is working fine, when I add the jar using the CLI command add jar. However when I put the jar in the hive/lib folder so that I dont ...
    Ehsan HaqEhsan Haq
    Jan 23, 2013 at 12:42 pm
    Jan 23, 2013 at 6:46 pm
  • Hi, I am new to hive, and I am trying to use postgresql9.1 as a meta data store for hive. I read and followed the tutorial posted by cloudera " ...
    Ehsan HaqEhsan Haq
    Jan 23, 2013 at 8:47 am
    Jan 23, 2013 at 5:35 pm
  • Hello everyone, I'm struggling with an exception I'm getting on a particular query that's driving me crazy! Here is the exception I get: java.lang.RuntimeException ...
    Fernando Andrés Doglio TurissiniFernando Andrés Doglio Turissini
    Jan 15, 2013 at 6:31 pm
    Jan 15, 2013 at 8:35 pm
  • Greetings all. I am getting frustrated with the documentation and lack of intuitiveness in Hive relating to timestamps and was hoping I could post here and get some clarification or other ideas. I ...
    John OmernikJohn Omernik
    Jan 4, 2013 at 4:04 pm
    Jan 6, 2013 at 12:13 am
  • new HiveHistoryViewer() throws ConcurrentModificationException when called concurrently by several threads. According to the stack trace, HiveHistory.parseLine use *private static Map<String, String ...
    Qiang WangQiang Wang
    Jan 4, 2013 at 8:28 am
    Jan 5, 2013 at 5:12 am
  • "show tables" shows the HDFS directories which correspond to Hive tables and various select queries show data from inside the files (each row of a file being a row of the overarching table that the ...
    Keith WileyKeith Wiley
    Jan 31, 2013 at 7:38 pm
    Jan 31, 2013 at 11:14 pm
  • Hi! After hitting the "curse of the last reducer" many times on LEFT OUTER JOIN queries, and trying to think about it, I came to the conclusion there's something I am missing regarding how keys are ...
    David MorelDavid Morel
    Jan 24, 2013 at 5:04 pm
    Jan 25, 2013 at 6:35 am
  • Hi All, Could you please let me know what would happen if we try to load a table from 2 different sources at the same time ? I had tried this earlier and got an error for 1 load job and while the ...
    Krishnan KKrishnan K
    Jan 24, 2013 at 2:44 pm
    Jan 24, 2013 at 4:03 pm
  • Hello, suppose I have the following table (orders) in MySQL: *************************** 1. row *************************** Field: id Type: int(10) unsigned Null: NO Key: PRI Default: NULL Extra ...
    Ibrahim YaktiIbrahim Yakti
    Jan 8, 2013 at 12:46 pm
    Jan 13, 2013 at 11:34 am
  • Hello, I was reading an article on web which tells about MapReduce local Task and use of hash table files and conditional tasks to improve performance of hive queries. Any idea how to implement this ...
    Santosh AchhraSantosh Achhra
    Jan 8, 2013 at 8:05 am
    Jan 8, 2013 at 6:25 pm
  • When I upgraded to 0.9.0, Im getting an exception when I try to create tables FAILED: Error in metadata: javax.jdo.JDODataStoreException: Insert of object ...
    Sam WilliamSam William
    Jan 4, 2013 at 10:22 pm
    Feb 18, 2013 at 10:00 pm
  • Hi, I'm running in Amazon on an EMR cluster with hive 0.8.1. We have a lot of other Hadoop jobs, but only started experimenting with Hive recently. I've been seeing a long pause after submitting a ...
    Marc LimotteMarc Limotte
    Jan 30, 2013 at 11:16 pm
    Feb 1, 2013 at 7:16 pm
  • Hi folks, I would like to run a list of generated HIVE queries. For each, I would like to retrieve the MR job_id (or ids, in case of multiple stages). And then, with this job_id, collect statistics ...
    Mathieu DesprieeMathieu Despriee
    Jan 30, 2013 at 10:04 am
    Jan 30, 2013 at 1:53 pm
  • I've noticed a few JIRA items for new features that are supposed to work in v0.10.0, but don't appear to actually work: https://issues.apache.org/jira/browse/HIVE-3066 - Add the option -database ...
    Dean WamplerDean Wampler
    Jan 28, 2013 at 5:45 pm
    Jan 29, 2013 at 3:18 pm
  • I ran into an interesting bug. Basically, if your FROM() source is a partitioned table and you use a where clause that prunes, all of the INSERT HERE SELECT * WHERE x=y ignores each specified where ...
    John OmernikJohn Omernik
    Jan 26, 2013 at 3:18 pm
    Jan 28, 2013 at 12:53 am
  • We mentioned it in our book and now I realize it's not actually implemented, even in 0.10.0. OOPS!! https://issues.apache.org/jira/browse/HIVE-2655 dean -- *Dean Wampler, Ph.D.* thinkbiganalytics.com ...
    Dean WamplerDean Wampler
    Jan 26, 2013 at 2:00 pm
    Jan 26, 2013 at 9:03 pm
  • Hi, I have a hive table which has pre-defined schema and I use RegexSerde to read data from the underlying files. I wanted to add a new column to this table and so after running the ALTER TABLE ...
    Viral BajariaViral Bajaria
    Jan 20, 2013 at 11:59 pm
    Jan 25, 2013 at 9:54 pm
  • Hi, I need to load the hdfs data into the Hive table. For example, Am having the twitter data and its updated daily using the streaming API. These twitter responses are stored into the HDFS Path ...
    VenkatramananVenkatramanan
    Jan 25, 2013 at 12:57 pm
    Jan 25, 2013 at 1:13 pm
  • Hi, Select col1,myudf(col2,col3) from table1; In what phase if map reduce an udf is executed. In the very beginning, I assumed that hive will be joining two tables., getting the required columns and ...
    Nagarjuna kanamarlapudiNagarjuna kanamarlapudi
    Jan 18, 2013 at 12:59 pm
    Jan 18, 2013 at 2:59 pm
  • Hi All, In order to achieve above I am researching on the feasibility of using a set of custom UADFs for distributive aggregate operations (e.g: sum, count etc..). Idea is to incorporate some state ...
    Buddhika chamithBuddhika chamith
    Jan 12, 2013 at 5:02 am
    Jan 17, 2013 at 5:30 pm
  • Hi all: I am using hive 0.9 and zookeeper 3.3.5, and I set hive.support.concurrency=true for locking. when I run query through hiveserver I keep receiving warnings like : 2013-01-05 12:03:56,109 WARN ...
    WzcWzc
    Jan 5, 2013 at 6:51 am
    Jan 7, 2013 at 4:36 pm
  • Is it possible to instruct hive to get only specific files from a partitioned external table? For example I have the following directory structure data/dd=2012-12-31/a1.txt data/dd=2012-12-31/a2.txt ...
    Oded PonczOded Poncz
    Jan 6, 2013 at 2:07 pm
    Jan 6, 2013 at 2:47 pm
  • Anyone else seeing this select col1, col2, col3, excol from sometablewithanarrayfield LATERAL VIEW explode(arcol) artab as excol Works just fine select col1, excol, count(1) as excount from ( select ...
    John OmernikJohn Omernik
    Jan 26, 2013 at 2:39 am
    Feb 14, 2013 at 8:02 am
  • I have Hbase running in distributed mode in a 4 node cluster working great. Installed Hive today on 5th box and pointed Hive to Mysql and Hbase. I start up the hive shell and go to make a table, ...
    Asher DevuystAsher Devuyst
    Jan 31, 2013 at 8:17 pm
    Feb 1, 2013 at 9:38 am
  • Hi, Do anyone know the meaning of these hive settings? The description of them are not clear to me. If someone can give me an example of how they shall be used, it would be great! <property <name ...
    Wu, James C.Wu, James C.
    Jan 24, 2013 at 11:13 pm
    Jan 25, 2013 at 6:13 am
  • How to run machine learning algorithms (whatever ML algorithms) directly in Hive? assume the input and output already stored as Hive tables. ps: I know mahout is available there, but would prefer run ...
    QiaoresearcherQiaoresearcher
    Jan 17, 2013 at 9:24 pm
    Jan 18, 2013 at 4:58 am
  • Hi all, On running a statement of the form "INSERT INTO TABLE tbl1 PARTITION(p1) SELECT x1 FROM tbl2", I get the following error: "Failed with exception java.lang.ClassCastException ...
    Krishna RaoKrishna Rao
    Jan 9, 2013 at 1:16 pm
    Jan 9, 2013 at 3:29 pm
  • Hello, I have created a view as shown below. *CREATE VIEW V1 AS* *select /*+ MAPJOIN(t1) ,MAPJOIN(t2) */ t1.f1, t1.f2, t1.f3, t1.f4, t2.f1, t2.f2, t2.f3 from TABLE1 t1 join TABLE t2 on ( t1.f2= t2.f2 ...
    Santosh AchhraSantosh Achhra
    Jan 8, 2013 at 9:12 am
    Jan 9, 2013 at 4:49 am
  • Hello Hive Users, After I execute below mention Alter statement, I get beloe mentioned error. Even though log shows that index file was moved to trash, I see index file present, however I am not able ...
    Santosh AchhraSantosh Achhra
    Jan 8, 2013 at 3:40 pm
    Jan 9, 2013 at 12:42 am
  • A particular query that I run fails with the following error: *** Job 18: Map: 2 Reduce: 1 Cumulative CPU: 3.67 sec HDFS Read: 0 HDFS Write: 0 SUCCESS Exception in thread "main" ...
    Krishna RaoKrishna Rao
    Jan 2, 2013 at 9:36 am
    Jan 4, 2013 at 2:29 pm
  • I'm building up a set of classes (objectinspectors and serdes) to allow hive queries over some data files I have. While I'm making it work, I don't fully grok all the concepts involved. Right now ...
    Lauren BlauLauren Blau
    Jan 25, 2013 at 11:26 am
    Jan 25, 2013 at 1:45 pm
  • Hi All, I'm working on hive 0.8.1. and meet following problem. I use function substr(item,-4,1) to process one item in hive table, and there is one row in which the content of the item is ...
    Yu YangYu Yang
    Jan 25, 2013 at 3:59 am
    Jan 25, 2013 at 6:10 am
  • Hi, I was successfully running command SHOW TABLES; which was viewing tables created @HDFS. I was doing operations on hive suddenly i lost all tables. But all tables are showing in warehouse. It ...
    Ashish negiAshish negi
    Jan 22, 2013 at 12:35 pm
    Jan 22, 2013 at 1:56 pm
  • I am perplexed if I run a transform script on a file by itself, it runs fine, outputs to standard out life is good. If I run the transform script on that same file (with the path and filename being ...
    John OmernikJohn Omernik
    Jan 17, 2013 at 3:33 am
    Jan 17, 2013 at 4:13 am
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions78
posts318
users92
websitehive.apache.org

92 users for January 2013

Dean Wampler: 29 posts Nitin Pawar: 23 posts Edward Capriolo: 15 posts David Morel: 13 posts Qiang Wang: 13 posts John Omernik: 12 posts Mark Grover: 11 posts Bejoy_ks: 9 posts Venkatramanan: 9 posts Ehsan Haq: 8 posts Mathieu Despriee: 8 posts Richard: 8 posts Santosh Achhra: 8 posts Tony Burton: 8 posts Manish Malhotra: 7 posts Ariel Marcus: 6 posts Chhaya Vishwakarma: 5 posts Alexander Alten-Lorenz: 4 posts Ashutosh Chauhan: 4 posts Buddhika chamith: 4 posts
show more
Archives