You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Shyam Sarkar <sh...@yahoo.com> on 2009/03/07 15:08:40 UTC

TIMESTAMP type

Hello,

I inspected the grammar Hive.g and decided to create a new type for TIMESTAMP. TIMESTAMP is not a primitive type or list type or map type. It is a timestamp type of the form TIMESTAMP(YYYYMMDDHHMMSS) which is different from other types.

Please let me know if there is any other suggestions.

Thanks,
shyam_sarkar@yahoo.com

Re: TIMESTAMP type

Posted by Zheng Shao <zs...@gmail.com>.
HI Shyam,

Conforming to the standard (like the MySQL 6.0 TIMESTAMP specification) is
definitely the ultimate goal we want to achieve.
Go ahead with the design and let us know when you have something ready for
review.

My previous point was basically that it might be much easier to add support
for TIMESTAMP using UDFs. Of course that is more like a short-term plan.
In the longer term we definitely need something like what you suggested.


Zheng

On Sat, Mar 7, 2009 at 8:30 PM, Shyam Sarkar <sh...@yahoo.com> wrote:

>
> Hi Zheng,
>
> From my earlier discussion with the group I got the suggestion that we
> should implement MySQL 6.0 TIMESTAMP specifications::
>
> http://dev.mysql.com/doc/refman/6.0/en/timestamp.html
>
> Please suggest if all the properties described for MySQL 6.0 can be
> done by UDF or not.
>
> Are you suggesting that UDF should be explicitely called all the time
> to decode TIMESTAMP string? This may require may different UDFs to be
> defined and called. Also this may be non-standard way to implement
> TIMESTAMP.
>
> Please suggest.
>
> Thanks,
> SHyam
>
>
>
> --- On Sat, 3/7/09, Zheng Shao <zs...@gmail.com> wrote:
>
> > From: Zheng Shao <zs...@gmail.com>
> > Subject: Re: TIMESTAMP type
> > To: hive-dev@hadoop.apache.org, shyam_sarkar@yahoo.com
> > Date: Saturday, March 7, 2009, 4:29 PM
> > The problem is that different people may have different
> > formats to store
> > TIMESTAMP.
> >
> > The easiest way to go is to declare the field as STRING,
> > and then use UDF to
> > manipulate the content.
> >
> > Zheng
> >
> > On Sat, Mar 7, 2009 at 6:08 AM, Shyam Sarkar
> > <sh...@yahoo.com> wrote:
> >
> > >
> > > Hello,
> > >
> > > I inspected the grammar Hive.g and decided to create a
> > new type for
> > > TIMESTAMP. TIMESTAMP is not a primitive type or list
> > type or map type. It is
> > > a timestamp type of the form TIMESTAMP(YYYYMMDDHHMMSS)
> > which is different
> > > from other types.
> > >
> > > Please let me know if there is any other suggestions.
> > >
> > > Thanks,
> > > shyam_sarkar@yahoo.com
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Yours,
> > Zheng
>
>
>
>


-- 
Yours,
Zheng

Re: TIMESTAMP type

Posted by Shyam Sarkar <sh...@yahoo.com>.
Hi Zheng,

>From my earlier discussion with the group I got the suggestion that we should implement MySQL 6.0 TIMESTAMP specifications::

http://dev.mysql.com/doc/refman/6.0/en/timestamp.html

Please suggest if all the properties described for MySQL 6.0 can be
done by UDF or not. 

Are you suggesting that UDF should be explicitely called all the time
to decode TIMESTAMP string? This may require may different UDFs to be
defined and called. Also this may be non-standard way to implement TIMESTAMP.

Please suggest.

Thanks,
SHyam



--- On Sat, 3/7/09, Zheng Shao <zs...@gmail.com> wrote:

> From: Zheng Shao <zs...@gmail.com>
> Subject: Re: TIMESTAMP type
> To: hive-dev@hadoop.apache.org, shyam_sarkar@yahoo.com
> Date: Saturday, March 7, 2009, 4:29 PM
> The problem is that different people may have different
> formats to store
> TIMESTAMP.
> 
> The easiest way to go is to declare the field as STRING,
> and then use UDF to
> manipulate the content.
> 
> Zheng
> 
> On Sat, Mar 7, 2009 at 6:08 AM, Shyam Sarkar
> <sh...@yahoo.com> wrote:
> 
> >
> > Hello,
> >
> > I inspected the grammar Hive.g and decided to create a
> new type for
> > TIMESTAMP. TIMESTAMP is not a primitive type or list
> type or map type. It is
> > a timestamp type of the form TIMESTAMP(YYYYMMDDHHMMSS)
> which is different
> > from other types.
> >
> > Please let me know if there is any other suggestions.
> >
> > Thanks,
> > shyam_sarkar@yahoo.com
> >
> >
> >
> >
> >
> >
> >
> 
> 
> -- 
> Yours,
> Zheng

Re: TIMESTAMP type

Posted by Zheng Shao <zs...@gmail.com>.
The problem is that different people may have different formats to store
TIMESTAMP.

The easiest way to go is to declare the field as STRING, and then use UDF to
manipulate the content.

Zheng

On Sat, Mar 7, 2009 at 6:08 AM, Shyam Sarkar <sh...@yahoo.com> wrote:

>
> Hello,
>
> I inspected the grammar Hive.g and decided to create a new type for
> TIMESTAMP. TIMESTAMP is not a primitive type or list type or map type. It is
> a timestamp type of the form TIMESTAMP(YYYYMMDDHHMMSS) which is different
> from other types.
>
> Please let me know if there is any other suggestions.
>
> Thanks,
> shyam_sarkar@yahoo.com
>
>
>
>
>
>
>


-- 
Yours,
Zheng