'Sqoop not returning the table Schema in sql server
I am trying to run sqoop command to get the SCHEMA of a table (ABC_XYZ) from SQL Server. But it's not returning the SCHEMA.
Command that is being Executed :
sqoop eval --connect $conStr --username $username --password $password --query ""SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS where table_name = 'ABC_XYZ' ""
My Output :
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | DATA_TYPE |
Desired Output :
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE
test_database dbo ABC_XYZ brand nvarchar
test_database dbo ABC_XYZ price int
test_database dbo ABC_XYZ first_name nvarchar
test_database dbo ABC_XYZ last_name nvarchar
test_database dbo ABC_XYZ age int
test_database dbo ABC_XYZ name nvarchar
test_database dbo ABC_XYZ age int
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
