Search Discussions

75 discussions - 211 posts

  • Hi, What is a good way to copy the entire content of a Hive metastore and insert it into another Hive metastore? The second metastore contains existing metadata that needs to be preserved. Both ...
    Steven WongSteven Wong
    Sep 30, 2011 at 9:06 pm
    Oct 12, 2011 at 1:47 am
  • Hello folks, I am fairly new to Hive and am wondering if you could share some of the best practices for storing/querying data with Hive. Here is an example of the problem I am trying to solve. The ...
    Mark GroverMark Grover
    Sep 2, 2011 at 5:19 pm
    Sep 12, 2011 at 7:12 pm
  • HI , can ny1 tell me how we can migrate hadoop or replace old hard disks with new big size hdd. actually i need to replace old hdd of 300 tbs to 1 tb so how can i do this efficiently!!! ploblem is to ...
    Vikas SrivastavaVikas Srivastava
    Sep 13, 2011 at 8:23 am
    Sep 15, 2011 at 5:30 am
  • Hi, I get this exception when I try to join two hive tables or even when I use a specific WHERE clause. "SELECT *" from any individual table seems to work fine. Any idea what is missing here. I am on ...
    Krish KhambadkoneKrish Khambadkone
    Sep 21, 2011 at 8:12 pm
    Sep 22, 2011 at 2:29 am
  • Hi, I have a situation where I need to do urldecode on one particular column. Is there any hive built in function available? Thank you, Chalcy
    Chalcy RajaChalcy Raja
    Sep 15, 2011 at 4:04 pm
    Sep 16, 2011 at 2:23 pm
  • Is it possible to load data into a hive table that is fed in using a unix pipe or streamed via a script? I've only seen streaming options when using SELECT TRANSFORM. Thanks in advance, Adriaan
    Adriaan TijsselingAdriaan Tijsseling
    Sep 12, 2011 at 1:00 pm
    Sep 12, 2011 at 2:26 pm
  • I want to access individual columns from a table created with row delimited by RegexSerde. For example, I have created a table as below: create table test ( col1 STRING, col2 STRING ) ROW FORMAT ...
    Sep 9, 2011 at 6:34 am
    Sep 9, 2011 at 11:22 am
  • Hi, I have a table created with CREATE TABLE raw(partition1 string, partition2 string, data string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE; I want to further process ...
    Adriaan TijsselingAdriaan Tijsseling
    Sep 17, 2011 at 9:18 pm
    Sep 18, 2011 at 10:04 pm
  • Dear All, I'm new to this list, and I hope I'm sending this to the right place. I'm currently using MySQL to store a large amount of visitor statistics. (Visits, clicks, etc....) Basically, each ...
    Benjamin FonzeBenjamin Fonze
    Sep 27, 2011 at 9:15 am
    Sep 27, 2011 at 5:13 pm
  • Hi, I have a table and index that look like <snip CREATE TABLE table_t1(id1 int, id2 int) CREATE INDEX table_t1_idx ON TABLE table_t1(id1) AS 'org.apache.hadoop.hive.ql.index.AggregateIndexHandler' ...
    Rohan mongaRohan monga
    Sep 20, 2011 at 6:26 am
    Sep 22, 2011 at 3:58 pm
  • Hey folks !! i tried to decommission datanode from hadoop cluster... steps i followed 1: add this in core site * <property <name dfs.hosts.exclude</name <value /home/hadoop/excludes</value <final ...
    Vikas SrivastavaVikas Srivastava
    Sep 19, 2011 at 7:20 am
    Sep 20, 2011 at 6:04 am
  • Hi users,I face this issue while connecting to hivestarted hive using: HIVE_PORT=10000 hive --service hiveserverStarting hive thrift server No information after it netstat shows: sudo netstat ...
    Siddharth TiwariSiddharth Tiwari
    Sep 12, 2011 at 7:59 am
    Sep 12, 2011 at 6:42 pm
  • When i run a query from the hive command line client i can see that it is being run as me (for example, in HDFS log i see INFO org.apache.hadoop.hdfs.server.namenode.FSNamesystem.audit: ugi=koert). ...
    Koert KuipersKoert Kuipers
    Sep 6, 2011 at 3:22 pm
    Sep 7, 2011 at 5:16 pm
  • Hey, I need some help regarding hive. I trying to benchmark Hive with TPCH SF 100 dataset. For a simple SPJ query I ran (Select count(*) from supplier,customer where s_nationekey=c_nationkey) , out ...
    Bharath vissapragadaBharath vissapragada
    Sep 27, 2011 at 8:22 am
    Sep 28, 2011 at 4:09 am
  • Hey amigos, I'm doing a EMR load for HDFS to S3 data. My example looks correct, but I'm getting an odd error. Since all the EMR data is in one directory, I'm copying the file to HDFS, then doing ...
    Bradford StephensBradford Stephens
    Sep 26, 2011 at 10:17 pm
    Sep 27, 2011 at 8:43 pm
  • Hi, I have an apache web log (sample below), and want to LOAD DATA INPATH. My fields are separated by a space, and those that contains spaces are enclosed in quotes. I tried this, ROW FORMAT ...
    Mark KerznerMark Kerzner
    Sep 22, 2011 at 8:59 pm
    Sep 25, 2011 at 3:59 am
  • I am using Hive 0.70. When I click on the "List Running Jobs" under Administration in the Hive GUI, I get this exception stack trace. HTTP ERROR 500 Problem accessing /hwi/admin_list_jobs.jsp. ...
    Krish KhambadkoneKrish Khambadkone
    Sep 16, 2011 at 12:40 am
    Sep 16, 2011 at 1:50 pm
  • Hello, I am using Hive 0.7 from cloudera cdh3u0 and I encounter a strange behavior when I update the serdeproperties of a table (for example for the RegexSerDe). If you have a simple partitioned ...
    Maxime BrugidouMaxime Brugidou
    Sep 13, 2011 at 1:03 pm
    Sep 14, 2011 at 11:45 am
  • Does anyone know the proper documentation for using the "CREATE INDEX" command in hive? The hive homepage doesn't have the information. Cheers, Adriaan
    Adriaan TijsselingAdriaan Tijsseling
    Sep 12, 2011 at 12:47 pm
    Sep 12, 2011 at 7:07 pm
  • Hi All, I am loading data into Hive from a script and I get following error WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in ...
    Praveen BathalaPraveen Bathala
    Sep 10, 2011 at 2:01 pm
    Sep 12, 2011 at 1:41 pm
  • Hi Everyone, is there any documentation regarding importing GoogleProtocolBuffer files into Hive. I'm scouring over the internet and the closest thing I came across ...
    Matias SilvaMatias Silva
    Sep 2, 2011 at 12:45 am
    Sep 2, 2011 at 7:13 pm
  • Hi, experts, the same command words in hive shell add jar WebLogAnalyzer-1.0-SNAPSHOT-jar-with-dependencies.jar; create temporary function get_browser as "com.shmsoft.webloganalyzer.GetBrowser"; ...
    Mark KerznerMark Kerzner
    Sep 28, 2011 at 10:56 pm
    Oct 2, 2011 at 9:34 pm
  • Hi Experts I'm currently struck when using compression with hive. My requirement is I need to store data in hive tables in LZO compressed format and should be able to retrieve the same successfully. ...
    Bejoy KsBejoy Ks
    Sep 29, 2011 at 4:51 pm
    Oct 1, 2011 at 10:07 am
  • Hi, I downloaded hive-0.7.1 and tried to run "ant test" However the build fails due to the following error: [ivy:retrieve] [FAILED ] hadoop#core;0.20.3-CDH3-SNAPSHOT!hadoop.tar.gz(source): The HTTP ...
    Ramya SunilRamya Sunil
    Sep 29, 2011 at 6:23 am
    Sep 30, 2011 at 5:23 pm
  • Hi, Hive experts, Would you see what I am doing wrong? For a simple test of breaking a text into words and putting these words into a table, I am doing this CREATE EXTERNAL TABLE books1 ( words ...
    Mark KerznerMark Kerzner
    Sep 28, 2011 at 1:46 am
    Sep 28, 2011 at 4:27 am
  • Hi, a simple question - if I have a book as a text, and I want to load it into a Hive table, with one word forming one entry, how should I do it? Thank you, Mark
    Mark KerznerMark Kerzner
    Sep 27, 2011 at 3:41 am
    Sep 27, 2011 at 12:43 pm
  • Hello, is there a way to configure Hive 0.7.1 so that it creates _SUCCESS files similar to Hadoop MapReduce and Pig? Hadoop has the property "mapreduce.fileoutputcommitter.marksuccessfuljobs" (see ...
    Michael G. NollMichael G. Noll
    Sep 15, 2011 at 1:59 pm
    Sep 27, 2011 at 9:32 am
  • Hi all, I've a question regarding compression and indexing. I would like to compress our Hive data (presently present as SequenceFile). Also, I have an index on this table and would like to maintain ...
    Mark GroverMark Grover
    Sep 15, 2011 at 9:17 pm
    Sep 16, 2011 at 2:07 pm
  • Dear All, Hello I have Hadoop 0-20.2 append version and HBase-0.90.3. I am trying to build Hive 0.9.0-SNAPSHOT for aforementioned versions of Hadoop and HBase. I have to integrate Hive and HBase. For ...
    Naila karimNaila karim
    Sep 14, 2011 at 5:28 am
    Sep 14, 2011 at 1:39 pm
  • Hello, How can I store EOL characters in Hive in String field? I'm using Hive 0.7 and I couldn't find anything about escaping or enclosing field values. I want to use <TAB as field delimiter and ...
    Wojciech LangiewiczWojciech Langiewicz
    Sep 7, 2011 at 11:31 am
    Sep 7, 2011 at 6:00 pm
  • Hi, I'm looking for the status of the Open source Apache project that is integrating Hive & Cassandra. I was under the impression that Datastax' Brisk is a commercial version of that but I'm looking ...
    Ayon SinhaAyon Sinha
    Sep 2, 2011 at 4:59 am
    Sep 2, 2011 at 9:52 pm
  • Hello, I am trying to run a "insert overwrite into ... select * from" query. The hadoop job submitted by Hive finishes successfully, but there seems to be an error while collecting results. Please ...
    Juwon LeeJuwon Lee
    Sep 30, 2011 at 10:58 pm
    Oct 3, 2011 at 9:17 pm
  • ----- Regards, Thulasi Ram P ---------- Forwarded message ---------- From: Thulasi Ram Naidu Peddineni <thulasiram333@gmail.com Date: Tue, Sep 27, 2011 at 11:21 PM Subject: Reg: Map joins in hive To: ...
    Thulasi Ram Naidu PeddineniThulasi Ram Naidu Peddineni
    Sep 27, 2011 at 5:59 pm
    Sep 27, 2011 at 9:57 pm
  • Hey folk, I m using python scripts to load the data in to hadoop, actually get lots of data on daily bases through ETL, data would be present in SQL tables as well as in CSV, Is there any better way ...
    Vikas srivastavaVikas srivastava
    Sep 27, 2011 at 1:57 pm
    Sep 27, 2011 at 2:32 pm
  • Hi, guys ・ I use hive to statistic the log , in order to parse log more flexible, I overwrite the TextInputFormat to parse the log, but if I only need compute log record contains some special ...
    Sep 22, 2011 at 11:42 am
    Sep 26, 2011 at 10:34 pm
  • hi, all. Currently, I get an exception: I can show partitons for the table 'a', but can't read or drop it, anybody know why? ps: I am using mysql to store the metadata for hive. hive show partitions ...
    Sep 15, 2011 at 6:41 am
    Sep 19, 2011 at 6:04 am
  • Hi, I am trying to access Hive 0.70 through jdbc. The hive server is running on port 6000. The server seems to be getting the call as I see a log msg being generated however it is failing with this ...
    Krish KhambadkoneKrish Khambadkone
    Sep 15, 2011 at 4:36 am
    Sep 15, 2011 at 10:03 pm
  • what is the easiest way to remove rows which are considered duplicates based upon a few columns in the rows? so "create table deduped as select distinct * from table" won't do...
    Koert KuipersKoert Kuipers
    Sep 14, 2011 at 9:11 pm
    Sep 15, 2011 at 11:13 am
  • Hello ! Since one week I'm trying to integrate Hive with my current HBase instance but whatever the results, all the stuff I follow to build it seems unconsistent... So before I go mad, maybe ...
    shazz Ngshazz Ng
    Sep 12, 2011 at 1:58 pm
    Sep 14, 2011 at 1:58 pm
  • Hi, Does anyone know how I can reduce the level of logging of the Hive History file which are created per Hive statement executed in the (default) location of /tmp/${user.name}/ ...
    Jasper KnulstJasper Knulst
    Sep 12, 2011 at 7:32 pm
    Sep 12, 2011 at 7:43 pm
  • Hi there, Anyone has early experience or simple example to write Hive UDF in scala? It's an open but non-resolved Hive JIRA ( https://issues.apache.org/jira /browse/HIVE-730 ) Thanks!:) Joe -- Joe ...
    Zhiyong XieZhiyong Xie
    Sep 10, 2011 at 7:42 pm
    Sep 12, 2011 at 2:18 pm
  • Please help I am trying to start hiveserver using following command, but it throws error ps help. I intend to integrate it with pentaho, if anyone hv relevant experience in doing so pls do help me ...
    Siddharth TiwariSiddharth Tiwari
    Sep 12, 2011 at 6:29 am
    Sep 12, 2011 at 6:40 am
  • Posted at https://cwiki.apache.org/confluence/display/Hive/ContributorMinutes20110907 Alan.
    Alan GatesAlan Gates
    Sep 9, 2011 at 7:54 pm
    Sep 9, 2011 at 8:39 pm
  • Hi , I am getting this error when I do a show schemas; FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: ...
    Eric HernandezEric Hernandez
    Sep 8, 2011 at 11:31 pm
    Sep 9, 2011 at 12:37 am
  • I've been trying to play with locks in hive using zookeeper but can't find documentation on how to configure it. I now have: <property <name hive.supports.concurrency</name <value true</value ...
    Bennie SchutBennie Schut
    Sep 7, 2011 at 2:02 pm
    Sep 8, 2011 at 7:50 am
  • Hello: I have analysis apache log from hive, but there is a problem When I write hive command in Script file and use crontab for schedule it The result is different with run in hive container The ...
    Sep 7, 2011 at 9:08 am
    Sep 7, 2011 at 9:24 am
  • Hive CLI runs this query just fine: select department_type, count(*) as total_walkins, count(distinct user_id) as unique_walkers from userstore.walkin w join locations.locations loc on w.location_id ...
    Ayon SinhaAyon Sinha
    Sep 1, 2011 at 2:34 am
    Sep 1, 2011 at 7:19 pm
  • hey guys, i'm planning to upgrade my hadoop cluster from 0.20.1 to 0.21 to take advantage of new bz2 splitting feature. i found a simple upgrade guide, http://wiki.apache.org/hadoop/Hadoop_Upgrade ...
    Shouguo LiShouguo Li
    Sep 1, 2011 at 6:42 pm
    Sep 1, 2011 at 7:04 pm
  • The October SF Hadoop users meetup will be held Wednesday, October 12, from 7pm to 9pm. This meetup will be hosted by Twitter at their office on Folsom St. *Please note that due to scheduling ...
    Aaron KimballAaron Kimball
    Sep 30, 2011 at 9:59 pm
    Sep 30, 2011 at 9:59 pm
  • hi, i'm looking at adding indexes to our hive tables, am wondering if anyone can share some thoughts on it. is there a performance/space trade off comparison or metrics? obviously it would be costly ...
    Shouguo LiShouguo Li
    Sep 30, 2011 at 6:50 pm
    Sep 30, 2011 at 6:50 pm
Group Navigation
period‹ prev | Sep 2011 | next ›
Group Overview
groupuser @
categorieshive, hadoop

69 users for September 2011

Adriaan Tijsseling: 17 posts Vikas Srivastava: 15 posts Krish Khambadkone: 11 posts Mark Grover: 9 posts Ashutosh Chauhan: 8 posts Ayon Sinha: 7 posts Edward Capriolo: 7 posts Koert Kuipers: 7 posts Mark Kerzner: 7 posts Siddharth Tiwari: 6 posts Steven Wong: 6 posts Aggarwal, Vaibhav: 5 posts Chalcy Raja: 5 posts Jasper Knulst: 5 posts Longmans163: 5 posts MIS: 5 posts Rohan monga: 4 posts Shouguo Li: 4 posts Ankit Jain: 3 posts Bradford Stephens: 3 posts
show more