Troubleshoot Issues with SET and MULTISET Tables - Geospatial Utilities

Teradata® Geospatial Utilities User Guide

Product
Geospatial Utilities
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
ygh1641301476787.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2519
Product Category
Teradata Tools and Utilities
C:\Program Files\Teradata\Client\17.20\bin>java com.teradata.geo.TDGeoImport -l hyvm111/ab2,ab2 -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected
==============================================
= Teradata GeoImport  VERSION 17.20.00.00    =
=                                            =
= Copyright 2014-2022 Teradata.              =
= ALL RIGHTS RESERVED.                       =
==============================================
DatabaseName = geouser
Data Source = C:\GeoSpatial\TestEnv\geodata
LayerName = customers
LOGMECH = TD2
Logon       = hyvm111/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.
C:\Program Files\Teradata\Client\17.20\bin>java -l hyvm111/ab2,ab -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected -m
==============================================
= Teradata GeoImport  VERSION 17.20.00.00    =
=                                            =
= Copyright 2014-2022 Teradata.              =
= ALL RIGHTS RESERVED.                       =
==============================================
DatabaseName = geouser
Data Source = C:\GeoSpatial\TestEnv\geodata
LayerName = customers
LOGMECH = TD2
Logon       = hyvm111/ab2,****
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