Hi,

I was wondering if there is an option to trigger queries. I use cloudera
CDH3.

I have tables in Hive which have textiles as input. I use Pentaho Data
Integrator for ETL -

I have to "clean" and export the data from a MongoDB as txt to hdfs.

So basically I create for the new data a new text file which I copy to the
right hdfs directory which is linked with my hive table. The table content
is automatically updated and I have to perform a query with the new data.
Is there a way that I can trigger - as soon I get new data - a sql query
(in form of a script or so) ?

 

Thx in advance

Ibo

 

You can take a look at --
https://issues.apache.org/jira/browse/HCATALOG-3
and
https://issues.apache.org/jira/browse/HIVE-2038

Thanks,
Aniket

On Sun, Nov 27, 2011 at 11:41 PM, Ibrahim Acet <[EMAIL PROTECTED]>wrote:

> Hi,****
>
> I was wondering if there is an option to trigger queries. I use cloudera
> CDH3.****
>
> I have tables in Hive which have textiles as input. I use Pentaho Data
> Integrator for ETL -****
>
> I have to “clean” and export the data from a MongoDB as txt to hdfs. ****
>
> So basically I create for the new data a new text file which I copy to the
> right hdfs directory which is linked with my hive table. The table content
> is automatically updated and I have to perform a query with the new data.
> Is there a way that I can trigger – as soon I get new data – a sql query
> (in form of a script or so) ? ****
>
>  ****
>
> Thx in advance ****
>
> Ibo****
>
> ** **
>
> **
>
>
>
> Regelung gemäß § 37a Absatz 4 HGB: WidasConcepts GmbH, Geschäftsführer:
> Thomas Widmann und Christian Kappert, Gerichtsstand Pforzheim,
> Registernummer: HRB 511442, Umsatzsteueridentifikationsnummer: DE205851091
>
>
>
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
> irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Mail sind nicht gestattet.
>
>
>
> This e- mail may contain confidential and/or privileged information. If
> you are not the intended recipient (or have received this e-mail in error)
> please notify the sender immediately and destroy this e-mail. Any
> unauthorized copying, disclosure or distribution of the material in this
> e-mail is strictly forbidden.
>
>
--
"...:::Aniket:::... Quetzalco@tl"