as a string and then develop your custom UDFs for any further
processing.
Regards
Bejoy KS
Sent from remote device, Please excuse typos
-Original Message-
From: Matouk IFTISSEN
Date: Mon, 8 Jul 2013 09:47:11
To:
Reply-To: user@hive.apache.org
Subject: Re: Need help in Hive
Hello
Hello,
Try this function in hive query:
1- transform your data (type integer ) in timestamp (linux),
then do this:
2- from_unixtimeyour_date_timestamp), 'mm:ss') AS time
Hope this, you will give help.
2013/7/8 Maheedhar Reddy
> Hi All,
>
> I have Hive 0.8.0 version installed in my single nod
Hi All,
I have Hive 0.8.0 version installed in my single node Apache Hadoop cluster.
I have a time column which is in format *MM:SS* (Minutes:seconds). I tried
the date functions to get the value in MM:SS format. But its not working
out.
Below is my column for your reference.
*Active Time*
*12:
distinct C;
Dump D;
Thanks & Regards
Yogesh Kumar Dhari
From: j...@omernik.com
Date: Sun, 14 Oct 2012 12:29:23 -0500
Subject: Re: NEED HELP in Hive Query
To: user@hive.apache.org
select NAME, DATE, URL, SUM(HITCOUNT) as HITCOUNT from yourtable group by NAME,
DATE, URL
That's the HIVE an
select NAME, DATE, URL, SUM(HITCOUNT) as HITCOUNT from yourtable group by
NAME, DATE, URL
That's the HIVE answer. Not sure the PIG answer.
On Sun, Oct 14, 2012 at 9:54 AM, yogesh dhari wrote:
> Hi all,
>
> I have this file. I want this operation to perform in *HIVE & PIG*
>
> NAME
Hi all,
I have this file. I want this operation to perform in HIVE & PIG
NAME DATE URL
HITCOUNT
timesascent.in2008-08-27
http://timesascent.in/index.aspx?page=tparchives
Thanks All :-)
Its working now :-)
Regards
Yogesh Kumar
> CC: user@hive.apache.org
> From: abhishek.dod...@gmail.com
> Subject: Re: Need Help in Hive storage format
> Date: Fri, 12 Oct 2012 08:47:41 -0400
> To: user@hive.apache.org
>
> Hi Yogesh,
>
> T
m, ignore, ignorecase, activat);
>>
>> What should be in the delimiter into PigStorage( )?
>> I have tried PigStorage('/001') but its showing errors.
>> What delimiter should we use.
>>
>> Please help and Suggest.
>>
>>
>> Thanks &
t; Please help and Suggest.
>
>
> Thanks & Regards
> Yogesh Kumar
>
>
>
>
>
>
> Subject: Re: Need Help in Hive storage format
> To: user@hive.apache.org
> From: bejoy...@yahoo.com
> Date: Thu, 11 Oct 2012 17:53:12 +
>
>
&
showing errors.
What delimiter should we use.
Please help and Suggest.
Thanks & Regards
Yogesh Kumar
Subject: Re: Need Help in Hive storage format
To: user@hive.apache.org
From: bejoy...@yahoo.com
Date: Thu, 11 Oct 2012 17:53:12 +
Hi Yogesh.
It should be a simple delimited file
Help in Hive storage format
Hi all,
If we run this query
insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from
NYSE_LOCAL;
{
( describe NYSE_LOCAL ;
exchangestring
symbolstring
ddatestring
openfloat
highfloat
lo
Hi all,
If we run this query
insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from
NYSE_LOCAL;
{
( describe NYSE_LOCAL ;
exchangestring
symbolstring
ddatestring
openfloat
highfloat
lowfloat
) }
ls /home/yogesh/Downloa
-- Forwarded message --
From: Vikas Srivastava
Date: Fri, Aug 26, 2011 at 6:21 PM
Subject: Need help in hive
To: user@hive.apache.org
Hey folks,
i m getting this error while running simple query...
like desc table.
i m using hive 0.7 and hadoop 0.20.2
*this is hive.log
Hey folks,
i m getting this error while running simple query...
like desc table.
i m using hive 0.7 and hadoop 0.20.2
*this is hive.log:-
*2011-08-26 17:41:56,403 ERROR DataNucleus.Plugin
(Log4JLogger.java:error(115)) - Bundle "org.eclipse.jdt.core" requires
"org.eclipse.core.resources" but i
14 matches
Mail list logo
