Troubleshoot Issues with SET and MULTISET Tables - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ngj1608578450889.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2519
lifecycle
previous
Product Category
Teradata Tools and Utilities
D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport -l hyvm111/ab2,ab2 -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
Logon       = hyvm111/ab2,ab2
Data Source = D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
connecting to hyvm111 ... connected!
Validating layer: SOIL_IA_REJECTED_SEQ
All layers successfully validated.
-------------------------------------------
Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427)
===========================================
Data importing finished successfully!
Importing time is 61.266
Bteq out shows as follows:
BTEQ -- Enter your SQL request or BTEQ command:
show table ab2.SOIL_IA_REJECTED_SEQ;
show table ab2.SOIL_IA_REJECTED_SEQ;
*** Text of DDL statement returned.
*** Total elapsed time was 1 second.
---------------------------------------------------------------------------
CREATE SET TABLE ab2.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO  (
      AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      SPATIALVER FLOAT,
      MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
      MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      GEOM SYSUDTLIB.ST_Geometry)
PRIMARY INDEX ( AREASYMBOL );
BTEQ -- Enter your SQL request or BTEQ command:
sel count(*) from ab2.SOIL_IA_REJECTED_SEQ;
sel count(*) from ab2.SOIL_IA_REJECTED_SEQ;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
   Count(*)
-----------
         91
Case 2: Database used is ab and -m option data files are from D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected.
D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport
-l hyvm111/ab,ab -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected -m
Logon       = hyvm111/ab,ab
Data Source = D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
connecting to hyvm111 ... connected!
Validating layer: SOIL_IA_REJECTED_SEQ
All layers successfully validated.
-------------------------------------------
Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427)
===========================================
Data importing finished successfully!
Importing time is 105.641
Bteq out shows as follows:
BTEQ -- Enter your SQL request or BTEQ command:
show table ab.SOIL_IA_REJECTED_SEQ;
show table ab.SOIL_IA_REJECTED_SEQ;
*** Text of DDL statement returned.
*** Total elapsed time was 1 second.
---------------------------------------------------------------------------
CREATE MULTISET TABLE ab.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO (
      AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
      SPATIALVER FLOAT,
      MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
      MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      GEOM SYSUDTLIB.ST_Geometry)
PRIMARY INDEX ( AREASYMBOL );
BTEQ -- Enter your SQL request or BTEQ command:
sel count(*) from ab.SOIL_IA_REJECTED_SEQ;
sel count(*) from ab.SOIL_IA_REJECTED_SEQ;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
   Count(*)
-----------
        427