AnsweredAssumed Answered

Schemas listing varies in different BI tools

Question asked by bijucyborg on May 27, 2017
Latest reply on May 30, 2017 by bijucyborg

Hi,

 

I have been testing drill with the mapr drill sandbox. I have a problem that different BI tools list the available schemas differently. By that I mean tableau and drill explorer (ODBC) list all, power BI (ODBC) some less and pentaho BI (JDBC) even lesser.  I'm using the same user id in all cases. 

Any input on what might be causing this, would be highly appreciated.

 

Using SQL LINE

sqlline> !connect jdbc:drill:zk=maprdemo:5181
scan complete in 329ms
Enter username for jdbc:drill:zk=maprdemo:5181: mapr
Enter password for jdbc:drill:zk=maprdemo:5181: ****
0: jdbc:drill:zk=maprdemo:5181>
0: jdbc:drill:zk=maprdemo:5181>
0: jdbc:drill:zk=maprdemo:5181> show schemas;
+---------------------+
| SCHEMA_NAME |
+---------------------+
| INFORMATION_SCHEMA |
| cp.default |
| dfs.clicks |
| dfs.default |
| dfs.logs |
| dfs.root |
| dfs.tmp |
| dfs.views |
| hcp.default |
| hive.default |
| maprdb |
| sys |
+---------------------+
12 rows selected (16.506 seconds)

 

Power BI

 

shows a subset of this.

 

 

Pentaho BI

 

an even smaller subset

 

Outcomes