nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thierry Hanot <tha...@infovista.com>
Subject Bug in queryRecord when caching is not activated
Date Wed, 02 Aug 2017 15:14:47 GMT
Hello
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
[cid:image001.jpg@01D2B879.7F499CD0]<http://www.infovista.com/>
23 avenue Carnot, 91300 Massy, France
thanot@infovista.com<mailto:thanot@infovista.com> | Tel: +33 1 64 86 79 57 | Mob: +33
6 70 10 40 44
www.infovista.com<http://www.infovista.com/> | www.ipanematech.com<http://www.ipanematech.com/>
| Blog<http://www.infovista.com/blog/> | LinkedIn<http://www.linkedin.com/companies/164363/InfoVista>
| Twitter<http://www.twitter.com/infovista> | YouTube<http://www.youtube.com/user/infovistautube>


Mime
View raw message