Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

can we use the hive udf in impala query

Highlighted

can we use the hive udf in impala query

Hi,

I am new to Hadoop ecosystem. For data ingestion into hive, we are using the sqoop import commands. Data ingestion populates data into staging tables. Now we need to clean up data & insert into the production hive tables. I have written the hive udf to simulate the auto increment feature which works fine in hive shell. Hive query is taking very long to clean up data, generate auto_incremented number. Impala queries are working good. I m wondering if i can use the same hive defined udf in the impala .

Is there any way to use the hive udf in the impala shell to generate the auto_incremented number?

Thanks

1 REPLY 1
Highlighted

Re: can we use the hive udf in impala query

@Nirvana India

Answer is Yes ..Link

We don't support impala so I suggest to ask this question in CDH community forum.

I highly recommend to stick with Hive and Tez & buckle up for LLAP :)

http://hortonworks.com/blog/stinger-next-enterprise-sql-hadoop-scale-apache-hive/

Don't have an account?
Coming from Hortonworks? Activate your account here