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 ?
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.