About sridarvs

sridarvs · ‎02-22-2019

Yes, try ORACLE TO_TIMESTAMP() format if needed

sridarvs · ‎02-22-2019

Can you try doing cast(col4 as timestamp) in your sqoop query. Not sure if it would work. But give a try

sridarvs · ‎02-22-2019

Requirement is to create a parquet file and send it to downstream. Issue is that parquet file is always getting created as empty file even when there is data in "select * from prov_cust" table.

sridarvs · ‎02-03-2019

Hi Team, Am trying to create a PARQUET file through the below INSERT OVERWRITE DIRECTORY '/data/dev1/consumption/crm' STORED AS PARQUET SELECT * FROM PROV_CUST; However, I could see that the file is always empty even when there are data in the table. Could someone please assist Thanks

sridarvs · ‎01-03-2019

Thanks, That worked like a charm

sridarvs · ‎01-02-2019

Sqoop import fails on empty table We have a batch job that looks into Teradata table and offloads delta records to HIVE based on a timestamp column. We havent used SQOOP incremental mode, Instead we have setup views on top of teradata tables and a joined to a control table to get the delta records. Once the offload is completed, We update the control table with MAX of timestamp record. However, We are stuck with below issue: Import failed: com.teradata.connector.common.exception.ConnectorException: Input source table is empty Could someone assist on the same? Regards, SV

Online	Offline
Last Visited	‎02-10-2020 04:33 PM

Member Since	‎10-20-2018 03:31 PM
Last Visited	‎02-10-2020 04:33 PM
Posts	9
Kudos received	1

Cloudera Community

Re: not able to query hive table built over parque...

Re: not able to query hive table built over parque...

Re: not able to query hive table built over parque...

Re: PARQUET File getting created as empty file

PARQUET File getting created as empty file

Re: Import failed: com.teradata.connector.common.e...

Import failed: com.teradata.connector.common.excep...