With the new version of hive ( show tables & show views) its split :
Show Views

Version information

Introduced in Hive 2.2.0 via HIVE-14558<https://issues.apache.org/jira/browse/HIVE-14558>.




In the Properties of the server for our Connection we have theses options:
[cid:image001.png@01D46076.B770D6E0]

We want a "Show Table &Show Views"

The "Default" options take to much on your cluster because we have to much table ( Around 300 tables)
(we are running this version of hive : In hive 3 : (/usr/hdp/3.0.1.0-187/hive/lib/hive-service-3.1.0.3.0.1.0-187.jar) )

License Key: 8140A12A4FC36646FDAFADC2A6A7D19BA3DC06B15E8304F0****************


Product: Aqua Data Studio

Version: 19.0.0

Build #: 55797

Build Date: 2018-Apr-24 08:26:49 AM


Operating Environment: Windows 10 (10.0, amd64) / Cp1252 / en / CA / Oracle Corporation 1.8.0_102-b14

Memory: Max=7,635,730,432; Total=1,227,358,208; Free=826,077,920; CPUs=12


In-Window Graphics Capabilities

Graphics Vendor: NVIDIA Corporation

OpenGL Renderer: GeForce GTX 1060 6GB/PCIe/SSE2

OpenGL Version: 4.5.0 NVIDIA 382.05

Double-Buffering: Enabled

Anti-Aliasing: Enabled

Anti-Aliasing Sample Count: 16

Hardware Acceleration: Enabled

Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8

Depth Bits: 16

Accumulation Buffer Bits: Red: 0 Green: 0 Blue: 0

Initialization Time: 2229 ms



Offscreen Graphics Capabilities

Graphics Vendor: Brian Paul

OpenGL Renderer: Mesa OffScreen

OpenGL Version: 2.1 Mesa 7.8.2

Double-Buffering: Disabled

Anti-Aliasing: Disabled

Anti-Aliasing Sample Count: 0

Hardware Acceleration: Disabled

Color Bits: Red: 8 Green: 8 Blue: 8 Alpha: 8

Depth Bits: 16

Accumulation Buffer Bits: Red: 16 Green: 16 Blue: 16

Initialization Time: 50 ms

Hardware PBuffer Available: No

Using PBuffer: No

Using Ram Buffer: Yes

Offscreen Rendering: Enabled

Offscreen Buffer Size: 800x600