{"body":"Red-Driver-DuckDB on  main [?] via 🦋 v6.d-moar\n✦ λ raku -I. -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   DISTINCT(\"iot\".device) as \"data_1\"\nFROM\n   \"iot\"\nBIND: []\nSQL : SELECT\n   count('*') as \"data_1\"\nFROM\n   \"iot\"\nWHERE\n   \"iot\".device = ?\nLIMIT 1\nBIND: [2]\nSQL : SELECT\n   SUM(\"red_projection_0\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_0\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_0\"\nLIMIT 1\nBIND: [2]\nSQL : SELECT\n   MIN(\"red_projection_1\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_1\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_1\"\nLIMIT 1\nBIND: [2]\nSQL : SELECT\n   MAX(\"red_projection_2\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_2\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_2\"\nLIMIT 1\nBIND: [2]\nSQL : SELECT\n   count('*') as \"data_1\"\nFROM\n   \"iot\"\nWHERE\n   \"iot\".device = ?\nLIMIT 1\nBIND: [1]\nSQL : SELECT\n   SUM(\"red_projection_3\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_3\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_3\"\nLIMIT 1\nBIND: [1]\nSQL : SELECT\n   MIN(\"red_projection_4\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_4\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_4\"\nLIMIT 1\nBIND: [1]\nSQL : SELECT\n   MAX(\"red_projection_5\".\"data_1\") as \"data_1\", COUNT('*') as \"data_2\", COUNT(\"red_projection_5\".\"data_1\") as \"data_3\"\nFROM\n   (\n      SELECT\n         \"iot\".value as \"data_1\"\n      FROM\n         \"iot\"\n      WHERE\n         \"iot\".device = ?\n   ) AS \"red_projection_5\"\nLIMIT 1\nBIND: [1]\n[[1 1 1 1 1] [2 1 2 2 2]]","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/qRAzNtzl","modified":1794776231,"id":"qRAzNtzl","size":2805,"lines":123,"own_paste":false,"theme":"","date":1794776231}