In our project we are loading input file into Hive tables using DSS and build summary tables on top of it which are used by tableau.
We are using Python recipe which will create HIve table based on input file. Input file has HEADER which will have Column names. So python recipe creates all these columns as STRING data type. Later using DSS we manually changes data type for these columns and using SYnc to Hive metastore we are syncing the Hive table.
This is well working for every other data types But for DATE data types when we are loading it into Hive table as STRING first and then changing it to DATE data type then it is syncing it in HIVE as Timestamp and Data is going as NULL. How to Keep DATE data types in HIVE using DSS although initially it is created as STRING.
We thouht of creating tables manually and disable Sync to hive metastore, But we are using DSS Flows to load summary tables. SUMMARY tables data types also changing as string or timestamp and date is not supporting.
How to handle this using DSS. Thanks in advance !!