nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Payne <>
Subject Re: Bug in queryRecord when caching is not activated
Date Wed, 02 Aug 2017 15:18:51 GMT

I believe the SQL you should be using is:

SELECT '1' AS a, '2' AS b

I.e., I don't think you should be using double-quotes there


On Aug 2, 2017, at 11:14 AM, Thierry Hanot <<>>

I’m trying to use a query record to do on the fly aggregation. I’m facing an issue when
I ‘m deactivating the cache ( As I need to be able to use expression langage to generate
the sql ).. When cache is disabled the execution failed :
QueryRecord[id=a3709a0c-015d-1000-8050-ecd623d10102] Unable to query StandardFlowFileRecord[uuid=8ba0d4c1-6fd0-4d76-9cb8-cf956cfe53ac,claim=StandardContentClaim
[resourceClaim=StandardResourceClaim[id=1501680615481-4, container=default, section=4], offset=928895,
length=15],offset=0,name=183093504803784,size=15] due to java.lang.RuntimeException: parse
failed: Encountered "as \"" at line 1, column 12.).

To demonstrate , please find a template configure with 2 queryRecord doing exactly the same
request. One have cache active , the other not. The one with caching work fine , the one without
caching fail. The request is very simple : select '1' as "a",'2' as "b" from FLOWFILE

I have not try enough different topology of request to highlight what part is problematic
, but I ‘m currently suspecting something related to double quote and literal.

Is there something wrong in my implementation ? Is it related to NiFi-4051 and no bug to open

Thanks in advance for your help.

Thierry Hanot
InfoVista | Chief Architect
23 avenue Carnot, 91300 Massy, France<> | Tel: +33 1 64 86 79 57 | Mob: +33
6 70 10 40 44<> |<>
| Blog<> | LinkedIn<>
| Twitter<> | YouTube<>


View raw message