nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thierry Hanot <>
Subject Bug in queryRecord when caching is not activated
Date Wed, 02 Aug 2017 15:14:47 GMT
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