Hadoop data exploration tools

2016-01-03 Thread Knowledge gatherer
Hi all, What are the various data exploration tools available supporting ANSI SQL commands, which can run fast to give the output. Thanks in advance...

Re: Error while executing Jobs in Hive

2014-09-22 Thread Knowledge gatherer
rami > > On Sun, Sep 21, 2014 at 3:06 AM, Knowledge gatherer < > knowledge.gatherer@gmail.com> wrote: > >> Whenever I am running a hive query - select * from table. It is running >> fine. But when i m trying to run a MR job for query - select count(*) from >

Error while executing Jobs in Hive

2014-09-21 Thread Knowledge gatherer
Whenever I am running a hive query - select * from table. It is running fine. But when i m trying to run a MR job for query - select count(*) from table. It is failing with the following error - Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile time: 1

Re: Loading xml to hive and fetching unbounded tags

2014-06-13 Thread Knowledge gatherer
Are you trying to capture this data in one column and use XPATH with UDF to get the data. On Wed, Jun 11, 2014 at 11:12 AM, harish tangella wrote: > Hi, > > Request you to help. > > Fetching unbounded tags from the xml in hive > > We tried with xpath but unable to get all the unbounded tag

Re: Storing and reading XML files in HIVE

2014-06-06 Thread Knowledge gatherer
U need to have a CustomSerde in Hive to read the XML files On Fri, Jun 6, 2014 at 2:58 PM, Yu Azuryy wrote: > AFAIK, Hive doesn't provide XMLInputFormat , so you had to write it by > yourself. > > > On Fri, Jun 6, 2014 at 5:23 PM, Ramasubramanian Narayanan < > ramasubramanian.naraya...@gmail.co