CODEWITHSUNDEEP
mongodbapache-drillsaiku
sanjay gaur
sanjay gaur

Reputation: 1

* coming in place of keys when connecting saiku with mongo using apache drill

I am using Apache drill in embedded mode and when I am able to connect to mongo and query in drill successfully.

However when I create a schema in saiku schema designer using driver as "org.apache.drill.jdbc.Driver" and URL as "jdbc:drill:drillbit=hostname:31010" the connection is successful and all collections are also fetched and shown as tables in saiku, but in place of column names "*" is coming and actual column names are not coming.

Dont know what I am missing on.

Upvotes: 0

Views: 172

Answers (1)

sanjay gaur
sanjay gaur

Reputation: 1

I figured out the solution and posting in case anyone could benefit. I had created a view in drill with select * from table. When I created view as select col1,col2... from table the issue got resolved.

Upvotes: 0

Related Questions