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?

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
Highlighted

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

Super Guru

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

Don't have an account?
Coming from Hortonworks? Activate your account here