FAQ

Search Discussions

73 discussions - 315 posts

  • Hi, I am executing the example, but got initial roadblock while trying out "Setting up tables (DDL Statements)" section. When I executed the command "hive create external table kv (key int, values ...
    Shouvanik HaldarShouvanik Haldar
    Sep 5, 2013 at 10:23 am
    Sep 11, 2013 at 8:41 pm
  • Hi every one , I am trying to import data from mongodb to hive . i got some jar files to connect mongo and hive . now how to import the data from mongodb to hive ? Thanks in advance. -- --Regards ...
    Sandeep NemuriSandeep Nemuri
    Sep 11, 2013 at 5:37 pm
    Sep 19, 2013 at 9:20 am
  • Over the past few weeks I have taken several looks over documents in our wiki. The page that strikes me as alarmingly poor is the: https://cwiki.apache.org/Hive/languagemanual.html This page has ...
    Edward CaprioloEdward Capriolo
    Sep 1, 2013 at 9:40 pm
    Sep 6, 2013 at 6:45 pm
  • we have a huge table, including browsing data for the past 5 years, let's say. now I want to take a few samples to play around with it. so I did select * from mytable limit 10; but it actually went ...
    YangYang
    Sep 29, 2013 at 8:40 pm
    Oct 7, 2013 at 4:44 am
  • Hello I found something strange. I tried a few queries, in WHERE 1. " " works, returns expected results 2. " " and "<" doesn't work, returns 0 result 3. "<" doesn't work, return 0 result 4. BETWEEN, ...
    Gary ZhaoGary Zhao
    Sep 26, 2013 at 6:34 pm
    Sep 26, 2013 at 9:21 pm
  • Hi, I have a file which is delimted by a tab. Also, there are some fields in the file which has a tab /t character and a new line /n character in some fields. Is there any way to load this file using ...
    Raj HadoopRaj Hadoop
    Sep 20, 2013 at 7:07 pm
    Oct 7, 2013 at 1:16 pm
  • I was reading the horton-works blog and found an interesting article. http://hortonworks.com/blog/stinger-phase-2-the-journey-to-100x-faster-hive/#comment-160753 There is a very interesting graphic ...
    Edward CaprioloEdward Capriolo
    Sep 12, 2013 at 2:19 pm
    Sep 17, 2013 at 8:23 pm
  • Hi All, I have setup Hadoop, hive setup and trying to load gzip file in hadoop cluster. Files are loaded successfully and can be view on web UI. While executing Select query it gives me the below ...
    Garg, RinkuGarg, Rinku
    Sep 16, 2013 at 8:04 am
    Sep 17, 2013 at 7:11 pm
  • The Apache Hive PMC has voted to make Yin Huai a committer on the Apache Hive project. Please join me in congratulating Yin! Thanks. Carl
    Carl SteinbachCarl Steinbach
    Sep 4, 2013 at 4:50 am
    Sep 4, 2013 at 8:13 am
  • I wrote a super simple UDF, but got some errors: UDF: package yy; import org.apache.hadoop.hive.ql.exec.UDF; import java.util.Random; import java.util.UUID; import java.lang.management.*; public ...
    YangYang
    Sep 30, 2013 at 8:48 pm
    Oct 4, 2013 at 2:07 pm
  • Hi, I have a lot of tweets saved as text. I created an external table on top of it to access it as textfile. I need to convert these to sequencefiles with each tweet as its own record. To do this, I ...
    Saurabh Bhatnagar (Business Intelligence)Saurabh Bhatnagar (Business Intelligence)
    Sep 29, 2013 at 5:36 pm
    Sep 30, 2013 at 7:56 pm
  • When I executing the query to create table in HIVE, I am getting this error. 'NoneType' object has no attribute 'columns' The table script below create external table test1( ----- ) PARTITIONED BY ...
    Shouvanik HaldarShouvanik Haldar
    Sep 30, 2013 at 1:54 pm
    Sep 30, 2013 at 5:00 pm
  • Hi, Can you please tell me if its possible to execute hive queries as different users? Can we create read-only access for hive? Please help. Thanks Shouvanik Sent from my Windows Phone -----Original ...
    Shouvanik HaldarShouvanik Haldar
    Sep 16, 2013 at 10:36 am
    Sep 19, 2013 at 10:05 am
  • Hi, I'm trying to run unit tests on Hive 11 (with a few patches such as 4619, 4003, 4403, 4900, 3632, 4942) and encountering compile-test errors. I got the same thing when I ran on Trunk or just the ...
    Eric ChuEric Chu
    Sep 3, 2013 at 9:40 pm
    Sep 9, 2013 at 9:54 pm
  • I am running Hive in EMR and since upgrading to 0.11 from 0.8.1.8 I have been getting NullPointerExceptions (NPE) for certain queries in our staging environment. Only difference between stage and ...
    Nathanial ThelenNathanial Thelen
    Sep 3, 2013 at 9:04 pm
    Sep 5, 2013 at 12:43 pm
  • Hello all, I'm a bit lost with using Hive and SequenceFiles. I loaded data using Sqoop from a RDBMS and stored as sequencefile. I jarred the class generated by sqoop and added it to my create table ...
    Artem ErvitsArtem Ervits
    Sep 20, 2013 at 3:19 pm
    Sep 24, 2013 at 5:07 pm
  • Hello to everyone, I'm working on the task of syncing data between two tables which have similar structure (read the same set of partitions). The tables are in different data centers and one table is ...
    Ivan KruglovIvan Kruglov
    Sep 23, 2013 at 2:49 pm
    Sep 24, 2013 at 2:50 pm
  • Hi All, We have setup apache "hive 0.11.0" services on Hadoop cluster (apache version 0.20.203.0). Hive is showing expected results when tables are stored as TextFile. Whereas, Hive 0.11.0's new ...
    Savant, KeshavSavant, Keshav
    Sep 19, 2013 at 12:05 pm
    Sep 20, 2013 at 3:00 pm
  • Hello. This is basically the same question I posted on stackoverflow: http://stackoverflow.com/questions/18812390/hive-subquery-and-group-by/18818115?noredirect=1#18818115 I know the query is a bit ...
    Mikael ÖhmanMikael Öhman
    Sep 16, 2013 at 8:24 am
    Sep 19, 2013 at 6:05 pm
  • hi,all: i use flume collect log data and put it in hdfs ,i want to use hive to do some caculate, query based on timerange,i want to use parttion table , but the data file in hdfs is a big file ,how ...
    Ch huangCh huang
    Sep 13, 2013 at 6:58 am
    Sep 14, 2013 at 12:04 am
  • Hi, I'm getting the below error while loading the data into hive table. return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask I used " LOAD DATA INPATH '/home/storage/mount1/tabled.txt' INTO ...
    Manickam PManickam P
    Sep 30, 2013 at 1:43 pm
    Oct 1, 2013 at 9:30 am
  • Using Hive V11, via Hue from CDH4, I can run my query, output 10 rows (limit 10) and download to a nice CSV or XSL file ... sometimes. :-( Sometimes, even when the run is error free, the download ...
    Sunderlin, MarkSunderlin, Mark
    Sep 18, 2013 at 6:08 pm
    Sep 30, 2013 at 6:18 pm
  • Guys, when i try to create a new table in hive i am getting the below error. FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException /user)FAILED: Execution ...
    Manickam PManickam P
    Sep 30, 2013 at 11:27 am
    Sep 30, 2013 at 12:15 pm
  • We have a UDF that is configured via a small properties file. What are the options for distributing the file for the task nodes? Also we want to be able to update the file frequently. We are not ...
    Stephen BoeschStephen Boesch
    Sep 13, 2013 at 11:57 pm
    Sep 14, 2013 at 12:29 am
  • hive select * from field_goal; OK tynes 44 miss tynes 40 miss tynes 33 make pete 20 make pete 21 make arnold 56 make arnold 22 make arnold 45 miss Time taken: 0.04 seconds, Fetched: 8 row(s) This ...
    Edward CaprioloEdward Capriolo
    Sep 1, 2013 at 9:04 pm
    Sep 2, 2013 at 9:44 pm
  • Hello, For unit testing, I would like to load from a local file data that has several columns, one is also Timestamp. The command I use is "LOAD DATA LOCAL INPATH... ". Unfortunately that column does ...
    Claudio ReggianiClaudio Reggiani
    Sep 30, 2013 at 10:07 am
    Sep 30, 2013 at 11:09 am
  • Hello, Though the documentation https://cwiki.apache.org/Hive/languagemanual-udf.html says they are same as AND and OR, they do not even get parsed. User gets parsing when they are used. Was that ...
    Amareshwari sriramdasuAmareshwari sriramdasu
    Sep 19, 2013 at 11:52 am
    Sep 20, 2013 at 4:31 am
  • Hello all, I'm trying to create a table with a column called "Comment" and I get the following exception: FAILED: ParseException line 12:0 mismatched input 'Comment' expecting Identifier near ',' in ...
    Artem ErvitsArtem Ervits
    Sep 16, 2013 at 9:08 pm
    Sep 19, 2013 at 1:00 am
  • Hi All I have a query where I want to convert the unix timestamp to an hour and day bucket like so. *select case * *when from_unixtime(cast(ts as bigint),'hh:mm') BETWEEN "00:01" and "00:15" then ...
    Robert LiRobert Li
    Sep 17, 2013 at 3:49 pm
    Sep 17, 2013 at 5:48 pm
  • Hello, Are there any examples of writing using ORC as aFileOutputFormat (and then as a FileInputFormat) in MapReduce jobs? I was looking at the source of ORCFIleInput/OutputFormat but couldn't quite ...
    Saptarshi GuhaSaptarshi Guha
    Sep 9, 2013 at 6:15 pm
    Sep 13, 2013 at 2:29 am
  • Sentry is a fine-grained role-based authorization system for Hive among others. We're planning to have a Sentry meetup in NYC coinciding with Hadoop World and Strata 2013. Please RSVP ...
    Shreepadma VenugopalanShreepadma Venugopalan
    Sep 4, 2013 at 10:41 pm
    Sep 5, 2013 at 12:37 am
  • when i submit a workflow,oozie return a jobid like this 0000002-130903214537362-oozie-*. But in this page http://oozie.apache.org/docs/3.3.2/DG_Examples.html ,the job id is ...
    李宏展李宏展
    Sep 3, 2013 at 2:44 pm
    Sep 4, 2013 at 11:49 pm
  • Hi, On executing "MSCK REPAIR TABLE table1", I get the below error. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask What can possibly be the error. Thanks, Shouvnik ...
    Shouvanik HaldarShouvanik Haldar
    Sep 30, 2013 at 5:11 pm
    Oct 1, 2013 at 4:08 pm
  • Dear Grid Users, Hadoop Services team is happy to announce that Tableau is now supported on KR. Please, come give it a try and provide your feedback. The steps to connect with Tableau are described ...
    Olga L. NatkovichOlga L. Natkovich
    Sep 30, 2013 at 9:13 pm
    Sep 30, 2013 at 11:11 pm
  • I have a query that doesn't use reducers as efficiently as I would hope. If I run it on a large table, it uses more reducers, even saturating the cluster, as I desire. However, on smaller tables it ...
    Keith WileyKeith Wiley
    Sep 30, 2013 at 6:32 pm
    Sep 30, 2013 at 8:41 pm
  • Hello I'm query a table and I'm able to filter column value is "NULL", but looks like some record doesn't even have "NULL" value. Is there a way to filter them out? Thanks Gary
    Gary ZhaoGary Zhao
    Sep 23, 2013 at 11:36 pm
    Sep 26, 2013 at 6:29 pm
  • The Apache Sentry team is happy to announce the release of Apache Sentry 1.2.0. Apache Sentry is a system to enforce fine grained role based authorization to data and metadata stored on a Hadoop ...
    Shreepadma VenugopalanShreepadma Venugopalan
    Sep 25, 2013 at 8:15 pm
    Sep 26, 2013 at 4:48 pm
  • This command fails: CREATE EXTERNAL TABLE avrotab PARTITIONED BY(dummy int) LOCATION '/user/user1/avrodata' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' INPUTFORMAT ...
    Sravya TirukkovalurSravya Tirukkovalur
    Sep 22, 2013 at 1:42 am
    Sep 24, 2013 at 6:11 am
  • Gary ZhaoGary Zhao
    Sep 22, 2013 at 6:25 am
    Sep 22, 2013 at 6:43 am
  • Hello Everyone, I am new to hive and I had a query related to building the Hive package from source. Is it possible to build a hive distribution against the latest hadoop source which is ...
    Wesley diasWesley dias
    Sep 21, 2013 at 10:19 am
    Sep 21, 2013 at 11:43 am
  • Hi All- I am trying to export a table in Hive 0.9, then import it into Hive 0.10 staging. Essentially moving data from a production import to staging. I used the EXPORT table command, however when I ...
    Brad RudermanBrad Ruderman
    Sep 17, 2013 at 9:23 pm
    Sep 19, 2013 at 5:26 pm
  • Hi guys I have to load data into the following data type in hive map <string,map<string,string Is there a way to define custom SEPARATORS (while creating the table) for - Inner map collection item - ...
    Sanjay SubramanianSanjay Subramanian
    Sep 13, 2013 at 11:42 pm
    Sep 14, 2013 at 12:55 am
  • Please bear with me, because this is a pretty large query. TL;DR: I'm doing a UNION ALL on a bunch of subqueries. The subqueries return no results, but the overall query does. Sadly, the constraints ...
    Chuck HardinChuck Hardin
    Sep 12, 2013 at 5:03 pm
    Sep 13, 2013 at 5:51 am
  • Hi - My name is Ellen Evans and I am a tech writer at Hortonworks. I've been asked to do some work on the Hive wiki. Currently I am supposed to update the Date data type with additional information ...
    Ellen EvansEllen Evans
    Sep 4, 2013 at 10:14 pm
    Sep 4, 2013 at 10:52 pm
  • I installed Hive 0.11. I believe hcatalog is now part of of it. I do not see a separate HCAT command. How does one use Command line hcat with hive now? Or do I need to install hcat separately?
    Ash GAsh G
    Sep 4, 2013 at 6:14 pm
    Sep 4, 2013 at 7:22 pm
  • I'm new to hive and trying to set it up in a relatively secure manner for a test environment. I want to use a remote metastore so MR jobs can access the DB. I seem to have things almost working, but ...
    Christopher PenneyChristopher Penney
    Sep 3, 2013 at 1:05 pm
    Sep 4, 2013 at 7:43 am
  • Hello Experts, when i try to execute the below query i'm getting error. Please help me to correct this. insert overwrite table table_baseline partition (sourcedate='base_2013_08') select * from ...
    Manickam PManickam P
    Sep 2, 2013 at 11:33 am
    Sep 3, 2013 at 6:19 pm
  • Hi guys, I have a hive JDBC server in production, It started lately to fail. In the log files I can see the following: 2013-09-02_10:42:53.13215 java.lang.IllegalStateException: Shutdown in progress, ...
    Guy DoulbergGuy Doulberg
    Sep 2, 2013 at 10:51 am
    Sep 3, 2013 at 3:39 pm
  • Hello Do you know if my scenario is supported or not, or how I may do it. Basically, I have an array in a recode, like [1, 2, 3] What I want is to explode it twice so I can have the following ...
    Gary ZhaoGary Zhao
    Sep 28, 2013 at 11:46 pm
    Sep 29, 2013 at 1:09 am
  • A desc extended command results in the following Table( tableName:table_namet, dbName:cybs_test, owner:<span class="m_body_email_addr" title="e24778c9815b9a079e520b2867df444d" xyz@abc.com</span , ...
    KayVajjKayVajj
    Sep 26, 2013 at 10:28 pm
    Sep 26, 2013 at 11:24 pm
Group Navigation
period‹ prev | Sep 2013 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions73
posts315
users107
websitehive.apache.org

107 users for September 2013

Nitin Pawar: 35 posts Shouvanik Haldar: 26 posts Edward Capriolo: 12 posts Gary Zhao: 12 posts Sanjay Subramanian: 12 posts Lefty Leverenz: 9 posts Artem Ervits: 8 posts Sandeep Nemuri: 6 posts Stephen Boesch: 6 posts Yin Huai: 6 posts Dean Wampler: 5 posts Manickam P: 5 posts Saurabh Bhatnagar (Business Intelligence): 5 posts Stephen Sprague: 5 posts Yang: 5 posts Ashutosh Chauhan: 4 posts Brad Ruderman: 4 posts Jagat Singh: 4 posts Raj Hadoop: 4 posts Sushanth Sowmyan: 4 posts
show more
Archives