User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.
  • See how to access JMP Marketplace - and - find, create & share add-ins to extend your JMP. Watch video.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Display Impala metadata information for Kudu tables in JMP "Select Tables for Query" window

Status: New Submitted by on ‎10-16-2023 03:55 AM
Comment

What inspired this wish list request? 

Unlike Oracle or SQL server database, we don't see any metadata information for tables in Kudu database (like primary key or indexed column), using an ODBC Impala connection

Technical details : driver Cloudera ODBC Driver for Impala DSN v2.6.13.1015 64bitsdriver Cloudera ODBC Driver for Impala DSN v2.6.13.1015 64bits

What is the improvement you would like to see? 

Same behavior as the other types of database (Oracle, Sql server) : display key icon for primary key columns for example

 

Why is this idea important? 

Displaying this information is crucial for advanced users querying our datalake database, in order to build coherent queries, espacially when joining tables, in order to avoid cartesian products and database server overload (timetout)