Hello Kshiva,
Hive is batch a processing system and not meant for real time
stuff as said by Nitin. Hive queries actually get converted into MapReduce
jobs under the hood and then give you the result. If you want to query your
data in real time, then give "Impala" a shot. It does the same thing which
Hive does, but in real time. It doesn't rely on MapReduce, instead uses MPP,
HTH
Best Regards,
Tariq
+91-9741563634
https://mtariq.jux.com/
On Tue, Dec 25, 2012 at 3:36 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote:
> Hive is not like mysql where u just query and get the results. It will
> take time based on data size and query. You may look at oozie if you want
> to build an application or look at penatho with hive integration
>
> Hive cli is not only for testing. You can build application using hive cli
> and scripting languages
>
> You can use hive thrift server and use it like jdbc but keep in mind this
> is never realtime
> On Dec 25, 2012 3:24 PM, "Kshiva Kps" <kshiva...@gmail.com> wrote:
>
>> Many Thanks, for your replay.
>>
>> But in real time if you want to develop application (jobs) in this case
>> CLI won't help us, CLI is for testing pls current if i'm worng, thanks.
>>
>> Many Thanks
>> Kshiva@ +91 9940163885
>>
>> On Tue, Dec 25, 2012 at 2:09 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote:
>>
>>> hive comes with a thrift server so you can connect via jdbc.
>>>
>>> you just want to execute queries, why dont u use hive cli ?
>>>
>>>
>>> On Tue, Dec 25, 2012 at 1:01 PM, Kshiva Kps <kshiva...@gmail.com> wrote:
>>>
>>>> Thnaks... sorry to ask you if possible could you pls advice on below
>>>> points
>>>>
>>>>>
>>>>> In general in Real time how we will write scripts
>>>>> 1. Java + hive query --could you pls ,if possibl share one program
>>>>> which can be executed thro Eclipse IDE many thanks.
>>>>>
>>>>> Thnks
>>>>> Siva @09940163885
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Nitin Pawar
>>>
>>
>>
