Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Can we take user input in hive

avatar
Contributor

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.

1 ACCEPTED SOLUTION

avatar
@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

View solution in original post

8 REPLIES 8

avatar
Master Guru

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

avatar
Contributor

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.

avatar
@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

avatar
Contributor

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

avatar

yes, that's right.

avatar
Contributor

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

avatar
Contributor

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

avatar

Please mark the best answer to close the discussion.