Is the question asking if there is similar "USING JAR" syntax for CREATE TABLE? No, there is not. But that might be a useful feature to add.
Thanks, Jason On Dec 31, 2014, at 6:25 AM, Ted Yu <yuzhih...@gmail.com> wrote: > Forwarding Niels' question to hive mailing list. > > On Wed, Dec 31, 2014 at 1:24 AM, Niels Basjes <ni...@basjes.nl> wrote: > >> Thanks for the pointer. >> This seems to work for functions. Is there something similar for CREATE >> EXTERNAL TABLE ?? >> >> Niels >> On Dec 31, 2014 8:13 AM, "Ted Yu" <yuzhih...@gmail.com> wrote: >> >>> Have you seen this thread ? >>> >>> http://search-hadoop.com/m/8er9TcALc/Hive+udf+custom+jar&subj=Best+way+to+add+custom+UDF+jar+in+HiveServer2 >>> >>> On Dec 30, 2014, at 10:56 PM, reena upadhyay <reena2...@gmail.com> wrote: >>> >>> Hi, >>> >>> I am using hadoop 2.4.0 version. I have created custom udf jar. I am >>> trying to execute a simple select udf query using java hive jdbc client >>> program. When hive execute the query using map reduce job, then the query >>> execution get fails because the mapper is not able to locate the udf class. >>> So I wanted to add the udf jar in hadoop environment permanently. Please >>> suggest me a way to add this external jar for single node and multi node >>> hadoop cluster. >>> >>> PS: I am using hive 0.13.1 version and I already have this custom udf jar >>> added in HIVE_HOME/lib directory. >>> >>> >>> Thanks >>> >>> -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
