adriangb commented on code in PR #22680:
URL: https://github.com/apache/datafusion/pull/22680#discussion_r3338154868
##########
benchmarks/sql_benchmarks/imdb/init/load_csv.sql:
##########
@@ -0,0 +1,170 @@
+CREATE EXTERNAL TABLE aka_name (
+ id integer unsigned NOT NULL,
+ person_id integer NOT NULL,
+ name varchar(218) NOT NULL,
+ imdb_index varchar(12),
+ name_pcode_cf varchar(5),
+ name_pcode_nf varchar(5),
+ surname_pcode varchar(5),
+ md5sum varchar(32)
+) STORED AS CSV LOCATION 'data/imdb/aka_name.csv' OPTIONS ('has_header'
'false', 'format.delimiter' ',', 'format.escape' '\');
+
+CREATE EXTERNAL TABLE aka_title (
+ id integer unsigned NOT NULL,
+ movie_id integer NOT NULL,
+ title varchar(553) NOT NULL,
+ imdb_index varchar(12),
+ kind_id integer NOT NULL,
+ production_year integer,
+ phonetic_code varchar(5),
+ episode_of_id integer,
+ season_nr integer,
+ episode_nr integer,
+ note varchar(72),
+ md5sum varchar(32)
+) STORED AS CSV LOCATION 'data/imdb/aka_title.csv' OPTIONS ('has_header'
'false', 'format.delimiter' ',', 'format.escape' '\');
+
+CREATE EXTERNAL TABLE cast_info (
+ id integer unsigned NOT NULL,
+ person_id integer NOT NULL,
+ movie_id integer NOT NULL,
+ person_role_id integer,
+ note varchar(992),
+ nr_order integer,
+ role_id integer NOT NULL
+) STORED AS CSV LOCATION 'data/imdb/cast_info.csv' OPTIONS ('has_header'
'false', 'format.delimiter' ',', 'format.escape' '\');
+
+CREATE EXTERNAL TABLE char_name (
+ id integer unsigned NOT NULL,
+ name varchar(478) NOT NULL,
+ imdb_index varchar(12),
+ imdb_id integer,
+ name_pcode_nf varchar(5),
+ surname_pcode varchar(5),
+ md5sum varchar(32)
+) STORED AS CSV LOCATION 'data/imdb/char_name.csv' OPTIONS ('has_header'
'false', 'format.delimiter' ',', 'format.escape' '\');
Review Comment:
We should also fix
https://github.com/apache/datafusion/pull/22660#discussion_r3338103032 here
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
