Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to get QueryRecord results in a single row rather than in muliple rows?

Highlighted

How to get QueryRecord results in a single row rather than in muliple rows?

New Contributor

Hi,

am running a select query on the flowfile content using queryRecord processor. However i want the results in single row rather than multiple rows. I tried using Group_concat but queryRecord supports only ANSI SQL standards. Group_Concat is not ANSI SQL command. Any suggestions to get this done?

1 REPLY 1

Re: How to get QueryRecord results in a single row rather than in muliple rows?

What does your query look like, what are the results, and what would you like to see in the single row/record?