We can connect to the Hive server through a squirrel client. All the queries are running fine. There are few minor issues that we see in this configuration and not sure if squirrel supports this for Hive or if we have to get the right plugin :
1 > Table names are not coming in the object tree for the Hive database. For any other databases, we can see table names in the object tree, but it is not coming for Hive. Are we missing any plugins or any configuration we have to manage?
2> We are not able to see the defined size of the column. For example, if we define any field ‘X’ as a string (20), then we should be able to see it through squirrel. For other databases, in the ‘Metadata’ tab of the result query, there is field ‘getprecision’ where we can see the defined size of any columns. It is not coming for the Hive tables.
Could you please help with these issues or direct me to the right forum to get the answers.