Unable to specify schema in tsqoopimport

[Anonymous]

Hi,

I am trying to ingest a cachedb into hdfs using sqoop. Sqoop import is always trying to connect to default schema. Is there a way to specify a schema under tsqoopimport ?(FYI : I am using talend open studio 6.1.1)

Thanks,
Chaitanya.

[Anonymous]

I dont have openstudio in front of me but there is a "specify columns" in the tsqoopimport component properties in the subscription license.

[Anonymous]

Thanks for the response Amula. I do see the "specify columns" thing here but if there is a table that has like 100 columns , Is there a way to select all of them like a select * by pointing to a specific schema ?