Table is in external schema, the column(tinyint) am getting error is not there in select statement and that column is not required in the query. Although I casted it into smallint still throwing error, help me to solve it.
Error : Invalid DataCatalog response for external table “ss_drn”.”drns”:Redshift does not support Hive Data Type “tinyint” for column “code_id”.Try defining column as “smallint”.[ErrorId:1-632fddeb-4ffcf9652088d9914998c026]