Loading Geography Data into SingleStore

data-load.sql

create database maps;
use maps;

create table countries (
  boundary geography,
  name_short varchar(3),
  name varchar(50),
  name_long varchar(50),
  abbrev varchar(10),
  postal varchar(4),
  iso_a2 varchar(2),
  iso_a3 varchar(3),
  name_formal varchar(100),
  shard key(name)
);

-- Thanks to Natural Earth for this data
-- https://www.naturalearthdata.com/downloads/
LOAD DATA INFILE '/data/natural_earth_countries_110m-1.csv'
INTO TABLE countries (boundary, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, name_short, @, name, name_long, @, @, @, abbrev, postal, name_formal, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, iso_a2, iso_a3, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @, @)
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

select * from countries order by name desc;

natural_earth_countries_110m-1.csv