question Re: Can we take user input in hive in Archives of Support Questions (Read Only)

Can we take user input in hive

rahulkatnihcet — Fri, 16 Sep 2022 10:26:51 GMT

I have an excel which has structured data, which I can take easily in Hbase. I can also do some modification as per the need. But at run time, Can i take the input from the user and then output the result based on the what user has inputted. Please guide me on this. Thanks in advance.

Re: Can we take user input in hive

sunile_manjee — Thu, 23 Jun 2016 10:44:27 GMT

@rahul jain I do not understand your question. Can you specify the use case?

Re: Can we take user input in hive

rahulkatnihcet — Thu, 23 Jun 2016 15:13:15 GMT

ok. Say I have the data in my hadoop data base as customer id , customer name and user wants to see the data for some specific customer Id's only not all the id's. Is there any graphical user interface we can have here where we can display the output based on user input.

Re: Can we take user input in hive

ssubhas — Thu, 23 Jun 2016 15:32:33 GMT

@rahul jain

You can use Hive view from Ambari and run queries on the Hive table.

As first step, hive table needs to be created on top the HDFS file.

Thanks and Regards,

Sindhu

Re: Can we take user input in hive

rahulkatnihcet — Thu, 23 Jun 2016 15:37:01 GMT

So in Hive user has to write the query on HDFS file everytime to get the desire result right ?

Re: Can we take user input in hive

rahulkatnihcet — Thu, 23 Jun 2016 15:38:09 GMT

So in Hive user has to write the query on HDFS file everytime to get the desire result right ?

Re: Can we take user input in hive

ssubhas — Thu, 23 Jun 2016 16:45:21 GMT

yes, that's right.

Re: Can we take user input in hive

rahulkatnihcet — Thu, 23 Jun 2016 17:28:01 GMT

If this is so then I got my answer..Thanks Sunile Thanks Sindhu

Re: Can we take user input in hive

ssubhas — Thu, 23 Jun 2016 18:30:10 GMT

Please mark the best answer to close the discussion.