Update of /cvsroot/monetdb/sql/src/test/Skyserver
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29195
Added Files:
Skyserver_import_v6.sql
Log Message:
Add test of Skyserver DR6 data load.
--- NEW FILE: Skyserver_import_v6.sql ---
COPY 88 RECORDS INTO Ap7Mag FROM 'DATA_DIR/Ap7Mag.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 111 RECORDS INTO Chunk FROM 'DATA_DIR/Chunk.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 339 RECORDS INTO DataConstants FROM 'DATA_DIR/DataConstants.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO DR3QuasarCatalog FROM 'DATA_DIR/DR3QuasarCatalog.dat.bz2'
USING DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO DR5QuasarCatalog FROM 'DATA_DIR/DR5QuasarCatalog.dat.bz2'
USING DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO ELRedShift FROM 'DATA_DIR/ELRedShift.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 3 RECORDS INTO Field FROM 'DATA_DIR/Field.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 148 RECORDS INTO FieldProfile FROM 'DATA_DIR/FieldProfile.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO First FROM 'DATA_DIR/First.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 21 RECORDS INTO Frame FROM 'DATA_DIR/Frame.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 354 RECORDS INTO HalfSpace FROM 'DATA_DIR/HalfSpace.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 40 RECORDS INTO HoleObj FROM 'DATA_DIR/HoleObj.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 10 RECORDS INTO Mask FROM 'DATA_DIR/Mask.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 20 RECORDS INTO Match FROM 'DATA_DIR/Match.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 10 RECORDS INTO MatchHead FROM 'DATA_DIR/MatchHead.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 673 RECORDS INTO Neighbors FROM 'DATA_DIR/Neighbors.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 125 RECORDS INTO ObjMask FROM 'DATA_DIR/ObjMask.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 128 RECORDS INTO PhotoObjAll FROM 'DATA_DIR/PhotoObjAll.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 4336 RECORDS INTO PhotoProfile FROM 'DATA_DIR/PhotoProfile.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 35 RECORDS INTO Photoz2 FROM 'DATA_DIR/Photoz2.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 128 RECORDS INTO Photoz FROM 'DATA_DIR/Photoz.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO PlateX FROM 'DATA_DIR/PlateX.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 15 RECORDS INTO ProfileDefs FROM 'DATA_DIR/ProfileDefs.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 30 RECORDS INTO ProperMotions FROM 'DATA_DIR/ProperMotions.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoBest FROM 'DATA_DIR/QsoBest.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoBunch FROM 'DATA_DIR/QsoBunch.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoCatalogAll FROM 'DATA_DIR/QsoCatalogAll.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoConcordanceAll FROM 'DATA_DIR/QsoConcordanceAll.dat.bz2'
USING DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoSpec FROM 'DATA_DIR/QsoSpec.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO QsoTarget FROM 'DATA_DIR/QsoTarget.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 58 RECORDS INTO Region2Box FROM 'DATA_DIR/Region2Box.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 360 RECORDS INTO RegionArcs FROM 'DATA_DIR/RegionArcs.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 73 RECORDS INTO Region FROM 'DATA_DIR/Region.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 78 RECORDS INTO RegionPatch FROM 'DATA_DIR/RegionPatch.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 12 RECORDS INTO Rmatrix FROM 'DATA_DIR/Rmatrix.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 3 RECORDS INTO RunQA FROM 'DATA_DIR/RunQA.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 9 RECORDS INTO RunShift FROM 'DATA_DIR/RunShift.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 47 RECORDS INTO SDSSConstants FROM 'DATA_DIR/SDSSConstants.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 73 RECORDS INTO Sector2Tile FROM 'DATA_DIR/Sector2Tile.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 23 RECORDS INTO Sector FROM 'DATA_DIR/Sector.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 2 RECORDS INTO Segment FROM 'DATA_DIR/Segment.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 50 RECORDS INTO SpecLineAll FROM 'DATA_DIR/SpecLineAll.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 36 RECORDS INTO SpecLineIndex FROM 'DATA_DIR/SpecLineIndex.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO SpecObjAll FROM 'DATA_DIR/SpecObjAll.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO SpecPhotoAll FROM 'DATA_DIR/SpecPhotoAll.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO SppLines FROM 'DATA_DIR/SppLines.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO SppParams FROM 'DATA_DIR/SppParams.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 48 RECORDS INTO StripeDefs FROM 'DATA_DIR/StripeDefs.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO Target FROM 'DATA_DIR/Target.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO TargetInfo FROM 'DATA_DIR/TargetInfo.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO TargPhotoObjAll FROM 'DATA_DIR/TargPhotoObjAll.dat.bz2'
USING DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1002 RECORDS INTO TargRunQA FROM 'DATA_DIR/TargRunQA.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO TileAll FROM 'DATA_DIR/TileAll.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 640 RECORDS INTO TiledTargetAll FROM 'DATA_DIR/TiledTargetAll.dat.bz2'
USING DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO TilingGeometry FROM 'DATA_DIR/TilingGeometry.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 24172 RECORDS INTO TilingInfo FROM 'DATA_DIR/TilingInfo.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 1 RECORDS INTO TilingRun FROM 'DATA_DIR/TilingRun.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 128 RECORDS INTO UberCal FROM 'DATA_DIR/UberCal.dat.bz2' USING DELIMITERS
'\t', '\n','"' NULL as 'NULL';
COPY 8 RECORDS INTO USNO FROM 'DATA_DIR/USNO.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
COPY 53 RECORDS INTO XCRedShift FROM 'DATA_DIR/XCRedShift.dat.bz2' USING
DELIMITERS '\t', '\n','"' NULL as 'NULL';
COPY 91 RECORDS INTO Zone FROM 'DATA_DIR/Zone.dat.bz2' USING DELIMITERS '\t',
'\n','"' NULL as 'NULL';
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
