Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to query data in hive based on condition which can accept be given by third party tool

Highlighted

How to query data in hive based on condition which can accept be given by third party tool

Expert Contributor

Hi,

I have a dashboard for reporting. I wan to create customized report from the data stored in hive. when user selects some parameters and based on that parameter the data should be fetch from Hive and report will be generate by reporting tool.

This is possible or not ? If yes than how can i achieve ?

Thank you.

3 REPLIES 3

Re: How to query data in hive based on condition which can accept be given by third party tool

Mentor

@heta desai

What BI tool are you using? Depending on the tool you will need to create a role with select privilege on that underlying database and give that role to the user to generate the report.

Most BI tools use ODBC/JDBC to connect with hive you can using LDAP to manage the groups who can create dashboards makes the work the users/groups more manageable.

Powerful Hortonworks Hive ODBC driver from progress

Hortonworks ODBC downloads

103450-odbc.png

HTH

Re: How to query data in hive based on condition which can accept be given by third party tool

Expert Contributor

@Geoffrey Shelton Okot

I am using SSRS. I am trying to connect Hortonworks Hive ODBC driver to connect Hive with SSRS. But i am facing some issue.

Re: How to query data in hive based on condition which can accept be given by third party tool

Expert Contributor

@Geoffrey Shelton Okot

When i need to accept some parameter from third party application/portal and needs data from hive based on that parameter how can i perform ?