Hi Mark,
Thanks for the workaround. This ETL trick always works! Only not sure for
SQL injection.
Do you have any idea about "configure the DBCP connection pool for hive" ?
It's painful and we can't wait until 1.0 release.
Thanks,
Bob
Mark Payne wrote
> You can also potentially use the ReplaceText processor to build a SQL
> statement
> using the Expression Language, something like:
>
> INSERT INTO MyTable (col1, col2) VALUES ('${attr1}', '${attr2}')
>
> -Mark
>
>
>> On Dec 1, 2015, at 5:10 PM, Bryan Bende <
> bbende@
> > wrote:
>>
>> Bob,
>>
>> I think this is slightly different than what you are suggesting, but in
>> the
>> next release there is a new AttributesToJson processor makes it very easy
>> to construct a new json document from values that were extracted using
>> EvaluateJsonPath.
>>
>> Would this makes things a bit easier for sending json to
>> ConvertJsonToSql?
>>
>> -Bryan
>>
>> On Tue, Dec 1, 2015 at 4:14 PM, Bob ZHao <
> bob.zhao.work@
> > wrote:
>>
>>> Hello,
>>>
>>> I like the idea to support more on tabular data target. But it might
>>> take a
>>> long way to go.
>>> I have a quick enhancement suggestion.
>>>
>>> *COnvertJSONToSQL* only support flat JSON structure instead of the
>>> complicated format -- this make sense. But since we can use
>>> *EvaluateJsonPath* to filter our the target fields, could we combine
>>> them
>>> together for a new one *PutPropertyToSQL*? This could be very quick
>>> implementation.
>>>
>>> NIFI needn't to worry about the complex of Json, user can use JsonPath
>>> to
>>> chop the fields and fragments for customization.
>>> Then put the result to target table. BTW, please use a trick to save the
>>> raw
>>> Json - by pointing to a column.
>>>
>>> Thanks,
>>> Bob
>>>
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://apache-nifi-developer-list.39713.n7.nabble.com/PutSQL-feature-enhancement-PutPropertyToSQL-tp5536.html
>>> Sent from the Apache NiFi Developer List mailing list archive at
>>> Nabble.com.
>>>
--
View this message in context:
http://apache-nifi-developer-list.39713.n7.nabble.com/PutSQL-feature-enhancement-PutPropertyToSQL-tp5536p5541.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
