#10861: Not clear and not the same using of SCHEMA in drop, Export, ERD, Query Builder and Schema Script Generator

slavakiev reported 2013-11-21T11:36:46Z · last modified 2014-04-29T17:58:58Z

Not clear and not the same using of SCHEMA in drop, Export, ERD, Query Builder and Schema Script Generator

Dev	tariqrahiman
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	15.0

Tested in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04( Hive 0.12.0( localhost,embeded mode), Hadoop 0.23.9)

In Hive( like in some other databases) schema means database. Currently in ADS using <DEFAULT> and/or <ALL Schemas> in schema field is not clear for the user and better to be changed on database name or be empty.

1. In message for droping table there is <DEFAULT>.<Table name> ( see attached screenshot). This is not clear for the user because default database exists and also he can have same <Table name> in different databases. Better change on real database name.

2. In Schema Script Generator,Query Builder, ERD schema field can be <ALL Schemas> or <DEFAULT> ( see attached screenshots) but in Export only <DEFAULT> ( see attached screenshot) . Necessary to have this the same in all dialogs and also keep SCHEMA column empty as it is in Query Builder.