I have a native data type in mysql and i just imported it into hive and the data type of the column has now become string .. Now i would like to know if there is any native data type in hive and What are the pros and cons of using string type in hive rather than (int)(thats what i expect ) type
And with the string type can i just run any type of queries like print the names of the person which has the maximum number of users between 1 PM and 3 PM and the table should have just name int(5) and login time (datetime ) {as per the mysql syntax}