SSDtests: spatialJoin_test.txt

File spatialJoin_test.txt, 549 bytes (added by jbecla, 9 years ago)
Line 
1mysql lsst_test < ./schema01.sql
2head -80001 USNOcat.csv > /tmp/lsst_tmp.csv
3mysql lsst_test -e "LOAD DATA INFILE '/tmp/lsst_tmp.csv' INTO TABLE X fields terminated by ',' lines terminated by '\n' IGNORE 1 LINES"
4mysql lsst_test -e "ALTER TABLE X ADD COLUMN objectId BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST"
5mysql lsst_test -e "ALTER TABLE X ADD COLUMN cosRadDecl FLOAT"
6mysql lsst_test -e "UPDATE X set cosRadDecl = COS(RADIANS(decl))"
7date; time mysql lsst_test < ./query_spatialJoin.sql; date
8mysql lsst_test -e 'select count(*) from X'