Re: Deleting empty rows from hive table through java

Thank you for your quick response... Directly loading the data from webpage to hive On Tue, Jan 5, 2016 at 1:44 PM, Vikas Parashar wrote: > What is the backend of your table? > Is it csv, orc or anything else! > > > Regards, > Vikas Parashar > > > On Tue, Jan 5

Deleting empty rows from hive table through java

Hello... Anyone please help me how to delete empty rows from hive table through java? Thanks in advance

Unable to create temp file for insert values java.net.URISyntaxException

Hello everyone... I am getting* Exception in thread "main" org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values java.net.URISyntaxException: Relative path in absolute URI: hdfs://localhos

Getting error while performing Insert query

hello..., iam using hive 1.1 and tez 0.7... Whenever iam trying to INSERT data into hive table using tez via java iam getting following error: *Exception in thread "main" org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10293]: Unable

Hive on tez error

I am trying to connect hive database(execution.engine value changed to tez) using Java code... In case of select query its working But in the case of INSERT getting an error: The error looks like. Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoo

getting mismatched input 'ROW' expecting error in hive creation

i want create a hive table using java code. my code is package com.inndata.services; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Connection; import java.sql.Statement; import java.sql.DriverManager; public class HiveCreateTable { private static String driverName = "co

Getting error in creating a hive table via java

I would like to create a table in hive using Java. Using the following way to do it: public class HiveCreateTable { private static String driverName = "com.facebook.presto.jdbc.PrestoDriver"; public static void main(String[] args) throws SQLException { // Register driver and create

execution error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.teztask error on hive on tez

iam using hive 1.0 and tez 0.7 whenever iam performing insert query its returns following error: execution error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.teztask

error on hive 1.2.0

iam using *hive 1.2.0* and *hadoop 2.6.0*. whenever iam running hive on my machine... *select* query works fine but in case of *count(*)* it shows following *error*: Diagnostic Messages for this Task: Container launch failed for container_1434646588807_0001_01_05 :*org.apache.hadoop.yarn.excep

error on hive insert query

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 table tablename values(intvalue,'string value');* and the error is : *FAILED: Execution Error, r

Re: hive on tez error

:9000 ESTABLISHED 8157/java On Tue, Jun 16, 2015 at 1:36 AM, Steve Howard wrote: > What does netstat -anp | grep 9000 show? > > On Mon, Jun 15, 2015 at 3:47 PM, Sateesh Karuturi < > sateesh.karutu...@gmail.com> wrote: > >> iam using hive 1.0.0 and tez 0.5.2.. whenever

hive on tez error

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 failed to write hdfs://localhost:9000/tmp/hive/hadoop/_tez_session_dir/002dad89-59b6-43c9-92f9-1c7b22

Re: hive tez error

couldn't find any error On Mon, Jun 8, 2015 at 1:24 PM, r7raul1...@163.com wrote: > hive -hiveconf hive.root.logger=DEBUG,consoleTo See some debug log > > -- > r7raul1...@163.com > > > *From:* Sateesh Karuturi > *Date:* 2015-06-08 1

Re: hive tez error

id is specified) On Mon, Jun 8, 2015 at 1:20 PM, Jianfeng (Jeff) Zhang < jzh...@hortonworks.com> wrote: > > Could you check the yarn app logs ? > > By invoking command : “yarn logs -applicationId" > > Best Regard, > Jeff Zhan

hive tez error

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 hive.execution.engine value is set to mr its works fine please help me out

create statement in hive 1.0.0.

anyone help me please... how to write insert statement in hive 1.0.0?

Exception in thread "main" java.lang.RuntimeException: java.io.IOException: Previous writer likely failed to write hdfs://localhost:8020/tmp/hive/hadoop/_tez_session_dir/39ba9c15-d9ed-4582-a4ce-11ae8b

I am using *hive 1.0.0* and *apache tez 0.5.2* 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 tez I get this error: Exception in thread "main" java.lang.RuntimeException: java.io.IOException:

Re: NoSuchMethodError when hive.execution.engine value its tez

n Tue, Jun 2, 2015 at 7:09 PM, Sateesh Karuturi < sateesh.karutu...@gmail.com> wrote: > 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. Bu

NoSuchMethodError when hive.execution.engine value its tez

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 tez I get this error: Exception in thread "main" java.lang.NoSuchMethodError: org.apache.tez.mapr