Custom UDF Not Working Properly

Hi, In Hive 0.14, I have written custom UDF to concat two strings by checking "null" string. This is my code. package org.apache.hadoop.hive.ql.udf; import org.apache.hadoop.hive.ql.exec.UDF; public class ConcatNullCheck extends UDF { public String evaluate(final String s, final String s1

Re: Custom UDF Not Working Properly

Hi, Please tell me steps to be followed to add Custom UDF in Hive 0.14 Source Code. Thanks Vengatesh Babu On Wed, 24 Dec 2014 20:26:53 +0530 vengatesh.babu <vengatesh.b...@zohocorp.com> wrote Hi, In Hive 0.14, I have written custom UDF to concat two strings by checking

Hive Query o/p to HDFS as CSV file

Hi, I want to write hive query output into HDFS file in CSV Format( comma separated). For LOCAL DIRECTORY: INSERT OVERWRITE LOCAL DIRECTORY '/home/test/result/' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' SELECT * from table; Above Works fine and writes output of query as CSV Format i

Hive order by not working properly

Hi, Hive order by not working properly with columns involved in functions. Column without function: SELECT ACCOUNTID from table order by ACCOUNTID; (Above query works fine in both HIVE & MYSQL) Column with function: SELECT concat('test_',ACCOUNTID) from table order by ACCOUNTID; In mysql , Above

Re: Hive Query o/p to HDFS as CSV file

Hi, How to write Hive query output to HDFS directory as CSV file(comma separated). Thanks Vengatesh Babu K M On Wed, 07 Jan 2015 11:46:39 +0530 vengatesh.babu<vengatesh.b...@zohocorp.com> wrote Hi, I want to write hive query output into HDFS file in CSV Format(

Create Function using JDBC Client ( All Databases)

Hi, I am using JDBC Client to create Function in hive (Ex. IFNULL) , it works only for database for which I created. If I want to use the same Function in another database, i need to create once again that function. Why Functions are working in single database alone ? Is there any way to c

HiveServer2 memory Problems

Dear all, I am running HiveServer2(0.14). Java Heap Memory keeps on increasing for failed Queries. Below Jira looks pretty same. https://issues.apache.org/jira/browse/HIVE-7021 They have given patch for that also. Whether given patch is correct ? If yes, why patch is not merged with default

Creating ORC File from Text format( CSV File)

Dear Team, In Java, Please suggest me way to write ORC File from text file delimited by comma without using Hive. With Hive : To create ORC FIle From Text File 1. Load Text file in Hive Table. 2. Create ORCTable stored as orc select * from TextTable(CTAS). I need to create ORC File from Text Fil

ORCStruct Constructor

Hi, Now ORCStruct constructor have only package level access. If i want use ORCStruct constructor to insert data to orc file from outside of hive, then ORCStruct should be public. 1. why is ORCStruct constructor not public ?. 2. How to write to ORC File without using hive ?. Than