FAQ

Hive > user > October 2011

Search Discussions

61 discussions - 199 posts

  • 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 SubhramanianDeepak 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 KerznerMark 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
    KiranprasadKiranprasad
    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 BurtonTony 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 anhTrang 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 ...
    BangbigBangbig
    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 KsBejoy 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 KrishnanSriram 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 JainAnkit 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 SichiJohn 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 EisbruchGabriel 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 PeddineniThulasi 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 GuptaMohit 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 PurkadShantian 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 anhTrang 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 GroverMark 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\)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 FloratouAvrilia 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 KerznerMark 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 GuptaNavin 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 ...
    JcfolsomJcfolsom
    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 SrivastavaVikas 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 DiaconeasaFlorin 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, MarkSunderlin, 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 ...
    MayureshMayuresh
    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 KuipersKoert 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 KerznerMark 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 JainAnkit 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 tiwariSiddharth 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 anhTrang 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 KennedyMatt 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 KerznerMark 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 ...
    JonathanJonathan
    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 YamadaHiroyuki 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 VaillsLaurent 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 BraeggerJoshua 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 KuipersKoert 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 anhTrang 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 liuLiming 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, AlexeyYakubovich, Alexey
    Oct 12, 2011 at 9:08 pm
    Oct 13, 2011 at 6:22 am
  • 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 FloratouAvrilia 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 GuptaNavin 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 SongChen 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 RutherglenJason 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 LiBing 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 YamadaHiroyuki 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 AntonyBenoy 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 LiBing 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 JainAnkit 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 CaberoMiguel Cabero
    Oct 17, 2011 at 4:22 pm
    Oct 17, 2011 at 4:22 pm
Oct 2011
12
Group Navigation
period‹ prev | Oct 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions61
posts199
users66
websitehive.apache.org

66 users for October 2011

Ankit Jain: 14 posts Mark Kerzner: 14 posts Bejoy Ks: 11 posts Vikas Srivastava: 11 posts Trang van anh: 10 posts Steven Wong: 9 posts Ashutosh Chauhan: 6 posts John Sichi: 6 posts Tony Burton: 6 posts Chinna Rao Lalam 72745: 5 posts Mark Grover: 5 posts Sriram Krishnan: 5 posts Alexander C.H. Lorenz: 4 posts Edward Capriolo: 4 posts Kiranprasad: 4 posts Koert Kuipers: 4 posts Navin Gupta: 4 posts Adriaan Tijsseling: 3 posts Avrilia Floratou: 3 posts Jander g: 3 posts
show more
Archives