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 <> wrote:

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