Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue in importing table using impala into hive database even when --hive-database command is given

Issue in importing table using impala into hive database even when --hive-database command is given

New Contributor

Below is the code that I am executing. Instead of creating the table in Hive Schema, it is creating a directory in home folder only and if i re-run it, it is not able to overwrite also and throwing "org.apache.hadoop.mapred.FileAlreadyExistsException" error. Any idea why it is not creating a table in mentioned hive schema. I am importing data from SQL Server. Am I missing something?

 

export QUEUE=" -Dmapreduce.job.queuename=myqu "
export HIVE_SCHEMA=myqu_schema
export PASS_STRING="--username X --password Y "
export CONN_STRING=" --connect jdbc:sqlserver://etc-R2yo-AS10:1433;DatabaseName=E"

 

 

sqoop import $QUEUE $CONN_STRING $PASS_STRING --hive-table ZZZZ -m2 --table ZZZZ – --schema dbo --compression-codec=snappy --as-parquetfile --hive-import --hive-database $HIVE_SCHEMA --direct --hive-overwrite --map-column-java $q

5 REPLIES 5

Re: Issue in importing table using impala into hive database even when --hive-database command is gi

Guru
@ysingla,

Can you please share the --verbose output of both the first run and second run for review? If the table is not created in Hive, the last step to load data into Hive might have failed.

Sqoop creates temp directories in HDFS before loading into Hive, so if that directory is not cleaned up properly, the second run will fail.

The log should tell more story.

Cheers
Eric

Re: Issue in importing table using impala into hive database even when --hive-database command is gi

New Contributor

@EricL    I also tried removing -- -- schema dbo option (as without this I am able to import data from other SQL Servers but this one is failing if it is not used) and below is the verbose output of it. It fails at "ERROR tool.ImportTool: Import failed: There is no column found in the target table COLABORA. Please ensure that your table name is correct."

 

Please set $ACCUMULO_HOME to the root of your Accumulo installation.
19/06/25 07:36:29 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.12.1
19/06/25 07:36:29 DEBUG tool.BaseSqoopTool: Enabled debug logging.
19/06/25 07:36:29 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/06/25 07:36:29 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
19/06/25 07:36:29 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
19/06/25 07:36:29 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
19/06/25 07:36:29 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
19/06/25 07:36:29 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
19/06/25 07:36:29 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!
19/06/25 07:36:29 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
19/06/25 07:36:29 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:sqlserver:
19/06/25 07:36:29 INFO manager.SqlManager: Using default fetchSize of 1000
19/06/25 07:36:29 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.SQLServerManager@777e85e4
19/06/25 07:36:29 INFO tool.CodeGenTool: Beginning code generation
19/06/25 07:36:29 INFO tool.CodeGenTool: Will generate java class as codegen_COLABORA
19/06/25 07:36:29 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : SELECT t.* FROM [COLABORA] AS t WHERE 1=0
19/06/25 07:36:29 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
19/06/25 07:36:30 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
19/06/25 07:36:30 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM [COLABORA] AS t WHERE 1=0
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CODIGO of type [4, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ACTIVO of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_APE_MAT of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_APE_PAT of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_AUTOSAL of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_AR_FEC of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_AR_HOR of type [1, 4, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BAN_ELE of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CARRERA of type [12, 40, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CHECA of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CIUDAD of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CLASIFI of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CODPOST of type [12, 8, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CONTRAT of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CREDENC of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CURP of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CALLE of type [12, 50, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_COLONIA of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EDO_CIV of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_RES of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EST_HOR of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EST_HOY of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ESTADO of type [1, 2, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ESTUDIO of type [1, 2, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EVALUA of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EXPERIE of type [12, 100, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_ANT of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_BAJ of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_BSS of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_CON of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_ING of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_INT of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_NAC of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_REV of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_VAC of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_1 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_2 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_3 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_4 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_5 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_6 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_7 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_FEC_8 of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_1 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_2 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_3 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_4 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_5 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_6 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_7 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_LOG_8 of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_1 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_2 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_3 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_4 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_5 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_6 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_7 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_8 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM_9 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM10 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM11 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM12 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM13 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM14 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM15 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM16 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM17 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_NUM18 of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_1 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_2 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_3 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_4 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_5 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_6 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_7 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_8 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB_9 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB10 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB11 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB12 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB13 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TAB14 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_1 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_2 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_3 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_4 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_5 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_6 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_7 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_8 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX_9 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX10 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX11 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX12 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX13 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX14 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX15 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX16 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX17 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX18 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX19 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_HABLA of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TURNO of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_IDIOMA of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFCRED of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFMANT of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFTASA of type [2, 15, 4]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_LA_MAT of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_LAST_EV of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_LUG_NAC of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_MAQUINA of type [12, 100, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_MED_TRA of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PASAPOR of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_INC of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_PER of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NOMYEAR of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NACION of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NOMTIPO of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NEXT_EV of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NOMNUME of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NOMBRES of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PATRON of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PUESTO of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_RFC of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SAL_INT of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SALARIO of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SEGSOC of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SEXO of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TABLASS of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TEL of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_VIVECON of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_VIVEEN of type [1, 2, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ZONA of type [12, 8, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ZONA_GE of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL1 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL2 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL3 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL4 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL5 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL6 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL7 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFTIPO of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL8 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL9 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DER_FEC of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DER_PAG of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_V_PAGO of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DER_GOZ of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_V_GOZO of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TIP_REV of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_MOT_BAJ of type [1, 3, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_SAL of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INF_INI of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INF_OLD of type [2, 15, 4]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_OLD_SAL of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_OLD_INT of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PRE_INT of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PER_VAR of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SAL_TOT of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TOT_GRA of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FAC_INT of type [2, 15, 5]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_RANGO_S of type [2, 15, 5]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CLINICA of type [1, 3, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NIVEL0 of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_NIV of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_PTO of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_AREA of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_TUR of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_KAR of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PENSION of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CANDIDA of type [4, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ID_NUM of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ENT_NAC of type [1, 2, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_COD_COL of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PASSWRD of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PLAZA of type [4, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_PLA of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DER_PV of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_V_PRIMA of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_SUB_CTA of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NETO of type [2, 15, 2]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_E_MAIL of type [12, 255, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_PORTAL of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DNN_OK of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_USRNAME of type [12, 40, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NOMINA of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_NOM of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_RECONTR of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_DISCAPA of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INDIGE of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FONACOT of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_EMPLEO of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column US_CODIGO of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_FEC_COV of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX20 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX21 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX22 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX23 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_G_TEX24 of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFDISM of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INFACT of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NUM_EXT of type [12, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_NUM_INT of type [12, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_INF_ANT of type [93, 23, 3]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column PRETTYNAME of type [12, 93, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column LLAVE of type [4, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TDISCAP of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ESCUELA of type [12, 40, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TESCUEL of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TITULO of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_YTITULO of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CTA_GAS of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_CTA_VAL of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_MUNICIP of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ID_BIO of type [4, 10, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_GP_COD of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TIE_PEN of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_TSANGRE of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_ALERGIA of type [12, 255, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_ACT of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_TIP of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_ROL of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_JEF of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_CON of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_PRA of type [1, 1, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BRG_NOP of type [12, 30, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_BANCO of type [1, 6, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_REGIMEN of type [5, 5, 0]
19/06/25 07:36:30 DEBUG manager.SqlManager: Found column CB_MIFARE of type [1, 1, 0]
19/06/25 07:36:30 ERROR tool.ImportTool: Import failed: There is no column found in the target table COLABORA. Please ensure that your table name is correct.

Re: Issue in importing table using impala into hive database even when --hive-database command is gi

New Contributor

@EricL  I removed -- -- schema dbo from the above statement and then I get this:

 

19/06/25 07:44:35 DEBUG manager.SqlManager: Found column CB_BRG_ACT of type [1, 1, 0]

It displays data types and column name it found and then in the end gives below error:

19/06/25 07:44:35 ERROR tool.ImportTool: Import failed: There is no column found in the target table COLABORA. Please ensure that your table name is correct

Re: Issue in importing table using impala into hive database even when --hive-database command is gi

Guru
@ysingla

Is it possible to share the full output? I can't tell at what stage it failed and full log should help. Or at least the lines around the error would be helpful.

Cheers
Eric

Re: Issue in importing table using impala into hive database even when --hive-database command is gi

New Contributor

@EricL Below is the log file: I have removed -- -- schema option from this as the sqoop import was working for some other sql server without -- --schema option..

 

19/06/26 07:15:15 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.12.1
19/06/26 07:15:15 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/06/26 07:15:16 INFO manager.SqlManager: Using default fetchSize of 1000
eval script is.........................CB_CODIGO=Double,CB_ACTIVO=String,CB_APE_MAT=String,CB_APE_PAT=String,CB_AUTOSAL=String,CB_AR_FEC=Date,CB_AR_HOR=String,CB_BAN_ELE=String,CB_CARRERA=String,CB_CHECA=String,CB_CIUDAD=String,CB_CLASIFI=String,CB_CODPOST=String,CB_CONTRAT=String,CB_CREDENC=String,CB_CURP=String,CB_CALLE=String,CB_COLONIA=String,CB_EDO_CIV=String,CB_FEC_RES=Date,CB_EST_HOR=String,CB_EST_HOY=String,CB_ESTADO=String,CB_ESTUDIO=String,CB_EVALUA=Double,CB_EXPERIE=String,CB_FEC_ANT=Date,CB_FEC_BAJ=Date,CB_FEC_BSS=Date,CB_FEC_CON=Date,CB_FEC_ING=Date,CB_FEC_INT=Date,CB_FEC_NAC=Date,CB_FEC_REV=Date,CB_FEC_VAC=Date,CB_G_FEC_1=Date,CB_G_FEC_2=Date,CB_G_FEC_3=Date,CB_G_FEC_4=Date,CB_G_FEC_5=Date,CB_G_FEC_6=Date,CB_G_FEC_7=Date,CB_G_FEC_8=Date,CB_G_LOG_1=String,CB_G_LOG_2=String,CB_G_LOG_3=String,CB_G_LOG_4=String,CB_G_LOG_5=String,CB_G_LOG_6=String,CB_G_LOG_7=String,CB_G_LOG_8=String,CB_G_NUM_1=Double,CB_G_NUM_2=Double,CB_G_NUM_3=Double,CB_G_NUM_4=Double,CB_G_NUM_5=Double,CB_G_NUM_6=Double,CB_G_NUM_7=Double,CB_G_NUM_8=Double,CB_G_NUM_9=Double,CB_G_NUM10=Double,CB_G_NUM11=Double,CB_G_NUM12=Double,CB_G_NUM13=Double,CB_G_NUM14=Double,CB_G_NUM15=Double,CB_G_NUM16=Double,CB_G_NUM17=Double,CB_G_NUM18=Double,CB_G_TAB_1=String,CB_G_TAB_2=String,CB_G_TAB_3=String,CB_G_TAB_4=String,CB_G_TAB_5=String,CB_G_TAB_6=String,CB_G_TAB_7=String,CB_G_TAB_8=String,CB_G_TAB_9=String,CB_G_TAB10=String,CB_G_TAB11=String,CB_G_TAB12=String,CB_G_TAB13=String,CB_G_TAB14=String,CB_G_TEX_1=String,CB_G_TEX_2=String,CB_G_TEX_3=String,CB_G_TEX_4=String,CB_G_TEX_5=String,CB_G_TEX_6=String,CB_G_TEX_7=String,CB_G_TEX_8=String,CB_G_TEX_9=String,CB_G_TEX10=String,CB_G_TEX11=String,CB_G_TEX12=String,CB_G_TEX13=String,CB_G_TEX14=String,CB_G_TEX15=String,CB_G_TEX16=String,CB_G_TEX17=String,CB_G_TEX18=String,CB_G_TEX19=String,CB_HABLA=String,CB_TURNO=String,CB_IDIOMA=String,CB_INFCRED=String,CB_INFMANT=String,CB_INFTASA=Double,CB_LA_MAT=String,CB_LAST_EV=Date,CB_LUG_NAC=String,CB_MAQUINA=String,CB_MED_TRA=String,CB_PASAPOR=String,CB_FEC_INC=Date,CB_FEC_PER=Date,CB_NOMYEAR=Double,CB_NACION=String,CB_NOMTIPO=Double,CB_NEXT_EV=Date,CB_NOMNUME=Double,CB_NOMBRES=String,CB_PATRON=String,CB_PUESTO=String,CB_RFC=String,CB_SAL_INT=Double,CB_SALARIO=Double,CB_SEGSOC=String,CB_SEXO=String,CB_TABLASS=String,CB_TEL=String,CB_VIVECON=String,CB_VIVEEN=String,CB_ZONA=String,CB_ZONA_GE=String,CB_NIVEL1=String,CB_NIVEL2=String,CB_NIVEL3=String,CB_NIVEL4=String,CB_NIVEL5=String,CB_NIVEL6=String,CB_NIVEL7=String,CB_INFTIPO=Double,CB_NIVEL8=String,CB_NIVEL9=String,CB_DER_FEC=Date,CB_DER_PAG=Double,CB_V_PAGO=Double,CB_DER_GOZ=Double,CB_V_GOZO=Double,CB_TIP_REV=String,CB_MOT_BAJ=String,CB_FEC_SAL=Date,CB_INF_INI=Date,CB_INF_OLD=Double,CB_OLD_SAL=Double,CB_OLD_INT=Double,CB_PRE_INT=Double,CB_PER_VAR=Double,CB_SAL_TOT=Double,CB_TOT_GRA=Double,CB_FAC_INT=Double,CB_RANGO_S=Double,CB_CLINICA=String,CB_NIVEL0=String,CB_FEC_NIV=Date,CB_FEC_PTO=Date,CB_AREA=String,CB_FEC_TUR=Date,CB_FEC_KAR=Date,CB_PENSION=Double,CB_CANDIDA=Double,CB_ID_NUM=String,CB_ENT_NAC=String,CB_COD_COL=String,CB_PASSWRD=String,CB_PLAZA=Double,CB_FEC_PLA=Date,CB_DER_PV=Double,CB_V_PRIMA=Double,CB_SUB_CTA=String,CB_NETO=Double,CB_E_MAIL=String,CB_PORTAL=String,CB_DNN_OK=String,CB_USRNAME=String,CB_NOMINA=Double,CB_FEC_NOM=Date,CB_RECONTR=String,CB_DISCAPA=String,CB_INDIGE=String,CB_FONACOT=String,CB_EMPLEO=String,US_CODIGO=Double,CB_FEC_COV=Date,CB_G_TEX20=String,CB_G_TEX21=String,CB_G_TEX22=String,CB_G_TEX23=String,CB_G_TEX24=String,CB_INFDISM=String,CB_INFACT=String,CB_NUM_EXT=String,CB_NUM_INT=String,CB_INF_ANT=Date,PRETTYNAME=String,LLAVE=Double,CB_TDISCAP=Double,CB_ESCUELA=String,CB_TESCUEL=Double,CB_TITULO=Double,CB_YTITULO=Double,CB_CTA_GAS=String,CB_CTA_VAL=String,CB_MUNICIP=String,CB_ID_BIO=Double,CB_GP_COD=String,CB_TIE_PEN=String,CB_TSANGRE=String,CB_ALERGIA=String,CB_BRG_ACT=String,CB_BRG_TIP=Double,CB_BRG_ROL=String,CB_BRG_JEF=String,CB_BRG_CON=String,CB_BRG_PRA=String,CB_BRG_NOP=String,CB_BANCO=String,CB_REGIMEN=Double,CB_MIFARE=String,
COLABORA
Warning: /opt/cloudera/parcels/CDH-5.12.1-1.cdh5.12.1.p0.3/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
19/06/26 07:15:18 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.12.1
19/06/26 07:15:18 DEBUG tool.BaseSqoopTool: Enabled debug logging.
19/06/26 07:15:18 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/06/26 07:15:18 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
19/06/26 07:15:18 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
19/06/26 07:15:18 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
19/06/26 07:15:18 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
19/06/26 07:15:18 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory
19/06/26 07:15:18 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop!
19/06/26 07:15:18 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
19/06/26 07:15:18 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:sqlserver:
19/06/26 07:15:18 INFO manager.SqlManager: Using default fetchSize of 1000
19/06/26 07:15:18 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.SQLServerManager@7e454bf7
19/06/26 07:15:18 INFO tool.CodeGenTool: Beginning code generation
19/06/26 07:15:18 INFO tool.CodeGenTool: Will generate java class as codegen_COLABORA
19/06/26 07:15:18 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : SELECT t.* FROM [COLABORA] AS t WHERE 1=0
19/06/26 07:15:18 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection.
19/06/26 07:15:19 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
19/06/26 07:15:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM [COLABORA] AS t WHERE 1=0
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CODIGO of type [4, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ACTIVO of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_APE_MAT of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_APE_PAT of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_AUTOSAL of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_AR_FEC of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_AR_HOR of type [1, 4, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BAN_ELE of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CARRERA of type [12, 40, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CHECA of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CIUDAD of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CLASIFI of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CODPOST of type [12, 8, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CONTRAT of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CREDENC of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CURP of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CALLE of type [12, 50, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_COLONIA of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EDO_CIV of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_RES of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EST_HOR of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EST_HOY of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ESTADO of type [1, 2, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ESTUDIO of type [1, 2, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EVALUA of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EXPERIE of type [12, 100, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_ANT of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_BAJ of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_BSS of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_CON of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_ING of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_INT of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_NAC of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_REV of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_VAC of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_1 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_2 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_3 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_4 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_5 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_6 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_7 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_FEC_8 of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_1 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_2 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_3 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_4 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_5 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_6 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_7 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_LOG_8 of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_1 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_2 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_3 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_4 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_5 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_6 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_7 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_8 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM_9 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM10 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM11 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM12 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM13 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM14 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM15 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM16 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM17 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_NUM18 of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_1 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_2 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_3 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_4 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_5 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_6 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_7 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_8 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB_9 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB10 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB11 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB12 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB13 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TAB14 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_1 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_2 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_3 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_4 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_5 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_6 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_7 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_8 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX_9 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX10 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX11 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX12 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX13 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX14 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX15 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX16 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX17 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX18 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX19 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_HABLA of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TURNO of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_IDIOMA of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFCRED of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFMANT of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFTASA of type [2, 15, 4]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_LA_MAT of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_LAST_EV of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_LUG_NAC of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_MAQUINA of type [12, 100, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_MED_TRA of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PASAPOR of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_INC of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_PER of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NOMYEAR of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NACION of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NOMTIPO of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NEXT_EV of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NOMNUME of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NOMBRES of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PATRON of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PUESTO of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_RFC of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SAL_INT of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SALARIO of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SEGSOC of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SEXO of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TABLASS of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TEL of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_VIVECON of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_VIVEEN of type [1, 2, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ZONA of type [12, 8, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ZONA_GE of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL1 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL2 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL3 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL4 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL5 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL6 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL7 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFTIPO of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL8 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL9 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DER_FEC of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DER_PAG of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_V_PAGO of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DER_GOZ of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_V_GOZO of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TIP_REV of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_MOT_BAJ of type [1, 3, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_SAL of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INF_INI of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INF_OLD of type [2, 15, 4]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_OLD_SAL of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_OLD_INT of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PRE_INT of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PER_VAR of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SAL_TOT of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TOT_GRA of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FAC_INT of type [2, 15, 5]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_RANGO_S of type [2, 15, 5]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CLINICA of type [1, 3, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NIVEL0 of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_NIV of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_PTO of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_AREA of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_TUR of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_KAR of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PENSION of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CANDIDA of type [4, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ID_NUM of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ENT_NAC of type [1, 2, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_COD_COL of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PASSWRD of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PLAZA of type [4, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_PLA of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DER_PV of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_V_PRIMA of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_SUB_CTA of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NETO of type [2, 15, 2]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_E_MAIL of type [12, 255, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_PORTAL of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DNN_OK of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_USRNAME of type [12, 40, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NOMINA of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_NOM of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_RECONTR of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_DISCAPA of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INDIGE of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FONACOT of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_EMPLEO of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column US_CODIGO of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_FEC_COV of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX20 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX21 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX22 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX23 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_G_TEX24 of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFDISM of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INFACT of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NUM_EXT of type [12, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_NUM_INT of type [12, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_INF_ANT of type [93, 23, 3]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column PRETTYNAME of type [12, 93, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column LLAVE of type [4, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TDISCAP of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ESCUELA of type [12, 40, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TESCUEL of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TITULO of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_YTITULO of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CTA_GAS of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_CTA_VAL of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_MUNICIP of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ID_BIO of type [4, 10, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_GP_COD of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TIE_PEN of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_TSANGRE of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_ALERGIA of type [12, 255, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_ACT of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_TIP of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_ROL of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_JEF of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_CON of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_PRA of type [1, 1, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BRG_NOP of type [12, 30, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_BANCO of type [1, 6, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_REGIMEN of type [5, 5, 0]
19/06/26 07:15:19 DEBUG manager.SqlManager: Found column CB_MIFARE of type [1, 1, 0]
19/06/26 07:15:19 ERROR tool.ImportTool: Import failed: There is no column found in the target table COLABORA. Please ensure that your table name is correct.