nothing has been done.
Anyway, thank you for your information and have a nice day! ☺
Br
Dejan
Von: Koji Kawamura [mailto:ijokaruma...@gmail.com]
Gesendet: Donnerstag, 19. April 2018 08:55
An: users@nifi.apache.org
Betreff: Re: Execute multiple HQL statements in PutHiveQL or SelectHiveQL
Hello
> Matt,
>
>
>
> No, there are no comments at all in this script.
>
>
>
> Br
>
> Dejan
>
>
>
> *Von:* Matt Burgess [mailto:mattyb...@apache.org]
> *Gesendet:* Montag, 16. April 2018 18:38
> *An:* users@nifi.apache.org
> *Betreff:* Re: Execute multiple
Matt,
No, there are no comments at all in this script.
Br
Dejan
Von: Matt Burgess [mailto:mattyb...@apache.org]
Gesendet: Montag, 16. April 2018 18:38
An: users@nifi.apache.org
Betreff: Re: Execute multiple HQL statements in PutHiveQL or SelectHiveQL
Dejan,
Are there any comments in your Hive
Dejan,
Are there any comments in your Hive "script"? If so I believe you need to
remove them [1]. When I've seen that issue, it's always been because of
comments before the SET line.
Regards,
Matt
[1] https://issues.apache.org/jira/browse/HIVE-1166
On Mon, Apr 16, 2018 at 12:29 PM, Krstic,
Hello,
I have Hive table from which I am trying to load data into other Hive table
(same server) and to do some transformations in between. The problem is, I need
to have two SET statements before I actually do INSERT statement and if I try
to separate everything with semicolons (as configured
>> ${field:startsWith('alpha'):or(
>>> ${field:startsWith('beta')}
>>> ):or(
>>> ${field:startsWith('gamma')}
>>> )}
>>>
>>> Or, alternatively, you could use a regex:
>>>
>>> ${field:matches( '(alpha|beta|gamma).*' )}
>
gt; ):or(
>> ${field:startsWith('gamma')}
>> )}
>>
>> Or, alternatively, you could use a regex:
>>
>> ${field:matches( '(alpha|beta|gamma).*' )}
>>
>> Thanks
>> -Mark
>>
>> On Aug 24, 2017, at 11:06 AM, Laurens Vets <laur.
rtsWith('gamma')}
)}
Or, alternatively, you could use a regex:
${field:matches( '(alpha|beta|gamma).*' )}
Thanks
-Mark
On Aug 24, 2017, at 11:06 AM, Laurens Vets <laur...@daemon.be> wrote:
Hi list,
Is it possible to have multiple 'or' statements in the query language?
What I want to do is route
On Aug 24, 2017, at 11:06 AM, Laurens Vets <laur...@daemon.be> wrote:
Hi list,
Is it possible to have multiple 'or' statements in the query language?
What I want to do is route on a JSON attribute if it doesn't start
with 'alpha', 'beta' or 'gamma'.
Is it possible to add a 3rd con
t;laur...@daemon.be> wrote:
>
> Hi list,
>
> Is it possible to have multiple 'or' statements in the query language? What I
> want to do is route on a JSON attribute if it doesn't start with 'alpha',
> 'beta' or 'gamma'.
>
> Is it possible to add a 3rd c
Hi list,
Is it possible to have multiple 'or' statements in the query language?
What I want to do is route on a JSON attribute if it doesn't start with
'alpha', 'beta' or 'gamma'.
Is it possible to add a 3rd condition to the following somehow:
${field:startsWith('alpha
...@apache.org]
> Sent: Friday, September 23, 2016 6:34 AM
> To: users@nifi.apache.org
> Subject: Re: PutHiveQL Multiple Ordered Statements
>
> Peter,
>
> Since each of your statements ends with a semicolon, I would think you could
> use SplitText with Enable Multiline M
Peter,
Since each of your statements ends with a semicolon, I would think you
could use SplitText with Enable Multiline Mode and a delimiter of ';'
to get flowfiles containing a single statement apiece, then route
those to a single PutHiveQL. Not sure what the exact regex would look
like but on
I have a PutHDFS processor drop a file, I then have a long chain of ReplaceText
-> PutHiveQL processors that runs a series of steps.
The below ~4 steps allow me to take the file generated by NiFi in one format
and move it into the final table, which is ORC with several Timestamp columns
(thus
14 matches
Mail list logo