You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by sudeep mishra <su...@gmail.com> on 2016/01/18 08:24:58 UTC

NiFi Hive processors

Hi,

Do we have any processors in NiFi to push data from HDFS to Hive and to
read adat from Hive?

Thanks & Regards,

Sudeep Shekhar Mishra

Re: NiFi Hive processors

Posted by sudeep mishra <su...@gmail.com>.

Thanks for your suggestion Jeremy.

On Mon, Jan 18, 2016 at 5:33 PM, Jeremy Dyer <jd...@gmail.com> wrote:

> Sudeep,
>
> There isn't currently a hive processor. This can be done though using a
> combination of PutHDFS and ExecuteSQL however. Since hive adheres to a
> scene on read mentality you can use PutHDFS to load the data in the
> appropriate HDFS directory a hive database/table will be expecting it. Once
> the data is in HDFS you can either use InvokeHTTP to call the hive rest API
> commands or ExecuteSQL to make a JDBC connection and execute sql. When
> using ExecuteSQL you will want to make sure that you use the hive
> standalone jar which contains all of the required classes
>
> Hope this helps
>
> Sent from my iPhone
>
> > On Jan 18, 2016, at 2:24 AM, sudeep mishra <su...@gmail.com>
> wrote:
> >
> > Hi,
> >
> > Do we have any processors in NiFi to push data from HDFS to Hive and to
> read adat from Hive?
> >
> > Thanks & Regards,
> >
> > Sudeep Shekhar Mishra
> >
> >
>



-- 
Thanks & Regards,

Sudeep Shekhar Mishra

+91-9167519029
sudeepshekharm@gmail.com

Re: NiFi Hive processors

Posted by Jeremy Dyer <jd...@gmail.com>.

Sudeep,

There isn't currently a hive processor. This can be done though using a combination of PutHDFS and ExecuteSQL however. Since hive adheres to a scene on read mentality you can use PutHDFS to load the data in the appropriate HDFS directory a hive database/table will be expecting it. Once the data is in HDFS you can either use InvokeHTTP to call the hive rest API commands or ExecuteSQL to make a JDBC connection and execute sql. When using ExecuteSQL you will want to make sure that you use the hive standalone jar which contains all of the required classes

Hope this helps

Sent from my iPhone

> On Jan 18, 2016, at 2:24 AM, sudeep mishra <su...@gmail.com> wrote:
> 
> Hi,
> 
> Do we have any processors in NiFi to push data from HDFS to Hive and to read adat from Hive?
>  
> Thanks & Regards,
> 
> Sudeep Shekhar Mishra
> 
>