process_streaming_count.sql 344 B

12345678910111213141516171819
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. -- not supported on windows
  4. $input = (
  5. SELECT String::JoinFromList(AsList(key, subkey, value), ",") AS Data FROM plato.Input1
  6. );
  7. $processed = (
  8. PROCESS $input USING Streaming::Process(TableRows(), "grep", AsList("[14]"))
  9. );
  10. SELECT
  11. *
  12. FROM $processed;
  13. SELECT
  14. COUNT(*)
  15. FROM $processed;