Grokbase Groups Hive user June 2015
FAQ

Search Discussions

105 discussions - 305 posts

  • I use hive 1.1.0 on hadoop 2.5.0 After I do some update operation on table u_data_txn. My table create many delta file like: drwxr-xr-x - hdfs hive 0 2015-02-06 22:52 ...
    R7raul1984R7raul1984
    Jun 11, 2015 at 5:10 am
    Jun 23, 2015 at 1:20 am
  • Hi, Can someone tell me how to read Json file in hive My Hive version is 0.14 the schema is something like this- {"columnA": "some_string", "columnB": 227958.0, "columnC": [0.0, 0.0, 0.0, 0.0], ...
    Ayazur RehmanAyazur Rehman
    Jun 5, 2015 at 2:30 pm
    Jun 5, 2015 at 5:14 pm
  • Hi, I am attempting to optimize a query using indexing. My current query converts an ipv4 address to a country using a geolocation table. However, the geolocation table is fairly large and the query ...
    Bennie LeoBennie Leo
    Jun 26, 2015 at 12:49 am
    Jun 30, 2015 at 9:41 pm
  • Hello, I'm running HortonWorks HDP 2.2.6, hive 0.14 alongside an ElasticSearch cluster For some reason Hive can't seem to connect to my ES cluster Using the ES SerDe (I'm using ...
    Erwan QueffélecErwan Queffélec
    Jun 29, 2015 at 12:30 pm
    Jun 29, 2015 at 2:02 pm
  • When I use hive 1.1.0 on tez 0.53 in hadoop 2.3.0: hive -v -e "set hive.execution.engine=tez;set mapred.job.queue.name=bi_etl;drop table TESTTMP.a_start;create table TESTTMP.a_start(id bigint);insert ...
    R7raul1984R7raul1984
    Jun 23, 2015 at 5:54 am
    Jun 29, 2015 at 7:34 am
  • I'm running into a peculiar issue with nested joins and outer select. I see this error on 1.1.0 and 1.2.0 but not 0.13 which seems like a regression. The following query produces no results: select ...
    Slava MarkeyevSlava Markeyev
    Jun 12, 2015 at 3:16 am
    Jun 13, 2015 at 7:16 am
  • Hi everyone, "FAILED: SemanticException [Error 10019]: Line 9:5 OR not supported in JOIN currently 'movieid_0' " Exception occur while executing the following query. But i need the add the ...
    Ravisankar ManiRavisankar Mani
    Jun 3, 2015 at 10:29 am
    Jun 4, 2015 at 9:56 pm
  • +user@hive -user@hbase to bcc Hi! This question is better handled by the hive user list, so I've copied them in and moved the hbase user list to bcc. -- Sean
    Sean BusbeySean Busbey
    Jun 5, 2015 at 5:56 pm
    Jun 23, 2015 at 5:41 am
  • Hi, I have one table with VARCHAR and CHAR datatypes. While reading data through hive, I am getting below error :-- Diagnostic Messages for this Task: Error: java.io.IOException ...
    Devansh SrivastavaDevansh Srivastava
    Jun 17, 2015 at 2:44 pm
    Jun 19, 2015 at 7:56 am
  • getting FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask error... when iam trying to perform insert operation on hive(set hive.execution.engine=tez). whenever ...
    Sateesh KaruturiSateesh Karuturi
    Jun 8, 2015 at 7:46 am
    Jun 8, 2015 at 8:25 am
  • Hi everyone, I am trying to schedule a hive query using Oozie, to perform aggregation on a table on data of a particular day and save the results in another table whenever every 24 hours. the schema ...
    Ayazur RehmanAyazur Rehman
    Jun 2, 2015 at 2:20 pm
    Jun 3, 2015 at 5:57 pm
  • Using Hive .13, I would like to export multiple partitions of a table, something conceptually like: EXPORT TABLE foo PARTITION (id=1,2,3) to ‘path’ Is there any way to accomplish this? Brian
    Brian JeltemaBrian Jeltema
    Jun 25, 2015 at 3:33 pm
    Jun 26, 2015 at 7:27 am
  • Hi everyone, I am unable to create an table in hive with primary key Example : create table Hivetable((name string),primary key(name)); Could please help about the primary key query? Regards, ...
    Ravisankar ManiRavisankar Mani
    Jun 2, 2015 at 8:37 am
    Jun 24, 2015 at 5:08 am
  • Hi all, I am using hive-1.1.0 and hadoop-2.6.0. am trying to rename a existing table in hive but it shows following error. hive *altertable testrename rename to testrenamebkp ;* *FAILED: Execution ...
    Mahesh SankaranMahesh Sankaran
    Jun 20, 2015 at 5:26 am
    Jun 22, 2015 at 6:58 am
  • how to make the default execution engine as Tez while running hive queries through hiveserver2 -- Thanking You, Ayazur Rehman +1 720 917 8540
    Ayazur RehmanAyazur Rehman
    Jun 10, 2015 at 2:26 pm
    Jun 11, 2015 at 3:44 pm
  • I am trying to run Hive 1.2.0 on Hadoop 2.6.0 (on a cluster, running CentOS). I am able to start Hive CLI and run queries. But once I try to start Hive's metastore (I trying to use the builtin derby) ...
    James PirzJames Pirz
    Jun 8, 2015 at 6:52 pm
    Jun 9, 2015 at 2:20 am
  • Hi, I am using hive 0.14. It fails to alter table concatenate occasionally (see the exception below). It is strange that it fails from time to time not predictable. Is there any suggestion/clue? hive ...
    PatchareePatcharee
    Jun 30, 2015 at 8:17 am
    Jun 30, 2015 at 3:06 pm
  • Hello Everyone, A quick question on the cost-based optimization module in Hive. Does the latest version support query plan generation with alternate join orders ? Thanks Raajay
    RaajayRaajay
    Jun 25, 2015 at 9:30 pm
    Jun 26, 2015 at 6:13 pm
  • Hello Everyone Can I define external table on cluster_1 pointing to hdfs location on cluster_2? I tried and got some strange exception in hive FAILED: Execution Error, return code 1 from ...
    Alexander PivovarovAlexander Pivovarov
    Jun 24, 2015 at 8:33 pm
    Jun 25, 2015 at 8:53 pm
  • Hello, Is there a way to update metadata in hive? Created database mydb; Created my_point_table; Created my_managed_table; Insert into my_managed_table from my_point_table; Now, Create ...
    Chagarlamudi, PrasanthChagarlamudi, Prasanth
    Jun 18, 2015 at 6:11 pm
    Jun 22, 2015 at 4:59 pm
  • I use Hive Version 1.1.0 in Cloudera CDH 5.4.0. I have created an external table: CREATE EXTERNAL TABLE *tableA* ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED AS INPUTFORMAT ...
    Julian KeppelJulian Keppel
    Jun 9, 2015 at 1:46 pm
    Jun 17, 2015 at 6:08 am
  • Hi All, I have a table which is partitioned on two columns (customer, date). I'm loading some data into the table using a Hive query. The MapReduce job completed within a few minutes and needs to ...
    Pradeep GollakotaPradeep Gollakota
    Jun 11, 2015 at 6:56 pm
    Jun 11, 2015 at 10:02 pm
  • Hi, I'm unable to retrieve rows from a table created in Tez when using MR as execution engine. This happens only when the create table statement has "union all". Here's a way to reproduce the issue ...
    Gufran Mohammed PathanGufran Mohammed Pathan
    Jun 10, 2015 at 5:19 pm
    Jun 11, 2015 at 5:09 pm
  • Hello, I would like to create a table based on a selection in hive. Currently I am creating a table based on a location which contains the source csv files and then deriving other tables from that ...
    Gary ClarkGary Clark
    Jun 9, 2015 at 1:45 pm
    Jun 9, 2015 at 5:27 pm
  • Hi Folks, We are experiencing an issue with Hive that we have not been able to solve for few weeks. Hiveserver2 stops logging with no error messages in the log but continues to process normally but ...
    Palani, MuthuKumar APalani, MuthuKumar A
    Jun 4, 2015 at 9:06 am
    Jun 7, 2015 at 9:26 pm
  • anyone help me please... how to write insert statement in hive 1.0.0?
    Sateesh KaruturiSateesh Karuturi
    Jun 4, 2015 at 10:58 am
    Jun 5, 2015 at 8:45 am
  • Hi Folks, Here is my query, select customerid as CustomerId from Customers It returns table with column name as 'customerid', ' CustomerId' in the query was not reflected into table. What shall i do ...
    Renuka BeRenuka Be
    Jun 4, 2015 at 4:44 am
    Jun 4, 2015 at 5:19 am
  • Hi, I have read couple of articles that say pig joins perform better compared to Hive joins... Is that true ? if Yes could you please explain the reason. Thanks
    Sreejesh sSreejesh s
    Jun 3, 2015 at 12:20 am
    Jun 3, 2015 at 4:07 pm
  • Hi, I have been trying to build a hook for hive. I require to get the tables affected by a query. I have tried to use HookContext.getQueryPlan ().getTableAccessInfo () . It is giving null value for ...
    Amitosh Anand, IDD M Tech, Computer Sci. & Engg., IIT (BHU) VaranasiAmitosh Anand, IDD M Tech, Computer Sci. & Engg., IIT (BHU) Varanasi
    Jun 2, 2015 at 9:15 am
    Jun 2, 2015 at 9:45 am
  • Hello developers, users, speakers, As part of ApacheCON's inaugural "Apache: Big Data", I'm hoping to see a "HBase: NoSQL + SQL" track come together. The idea is to showcase the growing ecosystem of ...
    Nick DimidukNick Dimiduk
    Jun 25, 2015 at 6:30 pm
    Jun 25, 2015 at 8:07 pm
  • Hi every one, how to get leftmost length of characters from the string in hive? In Mysql or sq has specific function "LEFT(string,length) " Could you please help any other way to achieve this ...
    Ravisankar ManiRavisankar Mani
    Jun 16, 2015 at 9:33 am
    Jun 23, 2015 at 5:05 am
  • Hi, I can see that two new counters have been added for hive (RECORDS_IN/RECORDS_OUT) in hive 0.14. Prior to this release which counters could be used to get the records read by hive job and records ...
    Hemanth MekaHemanth Meka
    Jun 16, 2015 at 12:25 pm
    Jun 23, 2015 at 5:02 am
  • Hi, Whats wrong with my settings? [127.0.0.1:10000] hive CREATE TABLE IF NOT EXISTS pagecounts_hbase (rowkey STRING, pageviews STRING, bytes STRING) STORED BY ...
    Ibrar AhmedIbrar Ahmed
    Jun 17, 2015 at 10:52 am
    Jun 23, 2015 at 3:54 am
  • Hi, I want to run Hive unit tests from IntelliJ but am unable to do so due to datanucleus issues. I tried a lot of options but always seem to be getting the same error. 1. Datanucleus plugin: I ...
    Rajat JainRajat Jain
    Jun 17, 2015 at 7:36 pm
    Jun 21, 2015 at 5:24 pm
  • Hi, I would like to request write access to Hive wiki. Thanks, Ben Tse
    Ben TseBen Tse
    Jun 18, 2015 at 9:14 pm
    Jun 20, 2015 at 4:58 am
  • Hi all, I have a pretty big Hive Query. I'm joining over 3 Hive-Tables which have thousands of lines each. I'm grouping this join by several columns. In the Hive-Shell this query only reach about ...
    Daniel KlingerDaniel Klinger
    Jun 17, 2015 at 9:35 pm
    Jun 18, 2015 at 3:04 pm
  • Hi Folks, I have a column with value like "10/05/2012" type of string. I need to convert this string to timestamp. Is there any way to convert string value date to specific format. Regards, Renuka N
    Renuka BeRenuka Be
    Jun 18, 2015 at 10:17 am
    Jun 18, 2015 at 10:25 am
  • Hi Folks, I have tried column name like (Order Details) with space, it cause error. Is there any way to mention column name with sapce. Regards, Renuka N
    Renuka BeRenuka Be
    Jun 18, 2015 at 5:15 am
    Jun 18, 2015 at 10:11 am
  • Hello, I am looking for an optimized way to merge small files in hive partitions into one big file. I came across Alter Table/Partition Concatenate ...
    Chagarlamudi, PrasanthChagarlamudi, Prasanth
    Jun 16, 2015 at 9:06 pm
    Jun 17, 2015 at 7:10 am
  • iam using *hive 1.0.0* and *tez 0.5.2.* when i set *hive.execution.engine* value in hive-site.xml to *tez*select query works well... but in case of *insert* getting error. the query is : *insert into ...
    Sateesh KaruturiSateesh Karuturi
    Jun 16, 2015 at 5:19 pm
    Jun 16, 2015 at 11:23 pm
  • Hi there, imagine you have a table of time-series transactions, e.g.: CREATE TABLE foobar (actor BIGINT, ts BIGINT, action STRING); containing the rows: 1 2000 bar 1 1000 foo 2 1500 foo An ...
    Michael HäuslerMichael Häusler
    Jun 13, 2015 at 1:50 pm
    Jun 16, 2015 at 4:27 pm
  • iam using hive 1.0.0 and tez 0.5.2.. whenever iam trying to open the hive getting following error: Exception in thread "main" java.lang.RuntimeException: java.io.IOException: Previous writer likely ...
    Sateesh KaruturiSateesh Karuturi
    Jun 15, 2015 at 7:47 pm
    Jun 15, 2015 at 8:08 pm
  • Hi guys, I’m playing with the code that integrates Hive on Tez, and have couple questions regarding to the resource allocation. To my understanding (correct me if I am wrong), Hive creates a DAG ...
    Yunqi ZhangYunqi Zhang
    Jun 10, 2015 at 12:08 am
    Jun 10, 2015 at 10:24 pm
  • I am trying to run Apache Hive 1.2.0 on Hadoop 2.6.0 on a cluster. My hadoop cluster comes up fine (I start hdfs and yarn) and then I create required tmp and warehouse directories in HDFS and I try ...
    James PirzJames Pirz
    Jun 6, 2015 at 2:29 am
    Jun 8, 2015 at 6:38 am
  • [edward@jackintosh apache-hive-1.2.0-bin]$ export HADOOP_HOME=/home/edward/Downloads/hadoop-2.6.0 [edward@jackintosh apache-hive-1.2.0-bin]$ bin/hive Logging initialized using configuration in ...
    Edward CaprioloEdward Capriolo
    Jun 7, 2015 at 3:06 pm
    Jun 7, 2015 at 7:10 pm
  • Hi everyone, I have selected specific column using aggregation . " FAILED: SemanticException [Error 10002]: Line 2:26 Invalid column reference 'contactid " . Exception occur while executing following ...
    Ravisankar ManiRavisankar Mani
    Jun 3, 2015 at 10:35 am
    Jun 4, 2015 at 4:07 am
  • Ravi, Use if condition .. it works .. Use ISNOTNULL instead, and give the replace field as third parameter for if condition. NOTE: false and null are together in if condition ...
    Teja KunapareddyTeja Kunapareddy
    Jun 3, 2015 at 6:24 am
    Jun 3, 2015 at 3:21 pm
  • I am using *hive 1.0.0* and *apache tez 0.4.1* When I configure hive to use tez I get an exception. In *hive-site.xml* when the *hive.execution.engine* value is mr its works fine. But if I set it to ...
    Sateesh KaruturiSateesh Karuturi
    Jun 2, 2015 at 1:41 pm
    Jun 3, 2015 at 4:01 am
  • Hi Team, On hive 0.13, I have a minimum reproduce for index on partition table issue: CREATE TABLE test_partition_index( id1 bigint, id2 bigint, id3 bigint) PARTITIONED BY ( dt string) row format ...
    Jim GreenJim Green
    Jun 29, 2015 at 9:35 pm
    Jul 6, 2015 at 7:12 pm
  • Maybe this is not exactly a question for hive user group, however I do not know of any other better place. So, I want to schedule data ingestion to hive from ftp. I have to schedule a job to check ...
    Ayazur RehmanAyazur Rehman
    Jun 30, 2015 at 8:45 pm
    Jul 1, 2015 at 3:38 am
Group Navigation
period‹ prev | Jun 2015 | next ›
Group Overview
groupuser @
categorieshive, hadoop
discussions105
posts305
users109
websitehive.apache.org

109 users for June 2015

Gopal Vijayaraghavan: 14 posts R7raul1984: 13 posts Ravisankar Mani: 11 posts Sateesh Karuturi: 11 posts Ayazur Rehman: 10 posts Lefty Leverenz: 8 posts @Sanjiv Singh: 8 posts Chinna Rao Lalam: 6 posts John Pullokkaran: 6 posts Nitin Pawar: 6 posts Bennie Leo: 5 posts Buntu Dev: 5 posts DU DU: 5 posts Edward Capriolo: 5 posts Erwan Queffélec: 5 posts James Pirz: 5 posts Renuka Be: 5 posts Slava Markeyev: 5 posts Alan Gates: 4 posts Devansh Srivastava: 4 posts
show more
Archives