Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

QueryRecord to find a Records which has array of String containing a value which starts with a field

avatar
New Contributor

Using QueryRecord i am trying to figure out how to find records which have a string in an array that start with a value

Given the below array, i would like only record which have a tag that start with '/test2/'

[
   {
    "name":"bob",
    "tags":[ "/test1/foo","/alpha"]
   }
   ,
   {
    "name":"bill",
    "tags":[ "/test2/blah","/beta"]
   }

]

 

 Selecting as if it a flattened string 

SELECT * FROM FLOWFILE WHERE tags LIKE '%/test2/blah']:

 i get an exception saying we cannot compare against an Array. 

Cannot apply 'LIKE' to arguments of type 'LIKE(<JAVATYPE(CLASS JAVA.LANG.STRING) ARRAY>

 

Treating it as a Record 

 

SELECT * FROM FLOWFILE WHERE RPATH_STRING(tags, '/') LIKE '/test2/%'

due to java.lang.String cannot be cast to org.apache.nifi.serialization.record.Record: java.lang.ClassCastException: java.lang.String cannot be cast to org.apache.nifi.serialization.record.Record

The errors i am getting make sense, but i am not sure how to inspect an array which is just strings. Can somebody help point me in the right direction? 

 

 

0 REPLIES 0