Affects Version/s: None
Fix Version/s: None
Component/s: Query Planning
As Alon Goldshuv mentioned in
Create table with serde such as OpenCSVSerde allows for creation of table with columns of arbitrary types. But 'describe table' would still return string datatypes, and so does selects on the table.
This is misleading and would result in users not getting intended results.
The create table ideally should disallow the creation of such tables with unsupported types.
Now consider this sql:
hive> select min(totalprice) from test;
in this case given my data, the result should have been 874.89, but the actual result became 100001.57 (as it is first according to byte ordering of a string type). this is a wrong result.
hive> desc extended test;
o_totalprice string from deserializer