{"body":"Red-Driver-DuckDB on  main [?] via 🦋 v6.d-moar took 6s\n✦ λ raku -I. -I../Red -e '\nmy $*RED-DEBUG = True;\nuse Red;\nred-defaults \"DuckDB\";\nred-do {\n my \\T = .read-csv: \"iot-sensor-100.csv\", :name<Iot>;\n say T.^all\n         .classify(*.device)\n         .map(-> (:key($device), :value($rows)) {\n                 my $count  = $rows.elems;\n                 my $values = $rows.map(*.value);\n                 [$device, $count, $values.sum / $count, $values.min, $values.max]\n          })\n          .sort(*[0])\n          .Array\n}\n\n'\nSQL : DESCRIBE SELECT * FROM read_csv('iot-sensor-100.csv')\nBIND: []\nSQL : CREATE TEMP VIEW \"iot\" AS SELECT \"id\" AS \"id\", \"device\" AS \"device\", \"value\" AS \"value\" FROM read_csv('iot-sensor-100.csv')\nBIND: []\nSQL : SELECT\n   \"red_projection_0\".\"data_1\" as \"data_1\", \"red_projection_0\".\"data_2\" as \"data_2\", \"red_projection_0\".\"data_3\" as \"data_3\", \"red_projection_0\".\"data_4\" as \"data_4\", \"red_projection_0\".\"data_5\" as \"data_5\"\nFROM\n   (\n      SELECT\n         '' || \"iot\".device  as \"data_1\", COUNT('*') as \"data_2\", (1.0 * SUM(\"iot\".value)) / COUNT('*') as \"data_3\", MIN(\"iot\".value) as \"data_4\", MAX(\"iot\".value) as \"data_5\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device IS NOT NULL\n      GROUP BY\n         \"iot\".device\n   ) AS \"red_projection_0\"\nORDER BY\n   \"red_projection_0\".\"data_1\"\nBIND: []\n[[1 1 1 1 1] [2 1 2 2 2]]","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/tGfP7d72","modified":1794782114,"id":"tGfP7d72","size":1370,"lines":40,"own_paste":false,"theme":"","date":1794782114}