[jira] Commented: (HIVE-83) Set up a continuous build of Hive with Hudson

2009-02-11 Thread dhruba borthakur (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-83?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12672739#action_12672739 ] dhruba borthakur commented on HIVE-83: -- I have got an hudson account named dhruba.

[jira] Updated: (HIVE-276) input3_limit.q fails under 0.17

2009-02-11 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-276: Attachment: HIVE-276.1.patch Modified the query to do another SORT at the end. I also thought about

[jira] Commented: (HIVE-278) Add HiveHistory to Hive web interface

2009-02-11 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12672744#action_12672744 ] Ashish Thusoo commented on HIVE-278: Looked at this with Suresh. We feel that the Session

[jira] Updated: (HIVE-278) Add HiveHistory to Hive web interface

2009-02-11 Thread Ashish Thusoo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-278?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashish Thusoo updated HIVE-278: --- Affects Version/s: (was: 0.2.0) 0.3.0 Fix Version/s: (was:

[jira] Commented: (HIVE-270) Add a lazy-deserialized SerDe for space and cpu efficient serialization of rows with primitive types

2009-02-11 Thread Joydeep Sen Sarma (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12672764#action_12672764 ] Joydeep Sen Sarma commented on HIVE-270: looks pretty good! for the LazyString

Need LOCALTIMESTAMP ?

2009-02-11 Thread Shyam Sarkar
Hello, Please help me to understand what I am going to implement for Timestamp. Do we need LOCALTIMESTAMP implementation? See the comparisons below:: = LOCALTIMESTAMP It's often important to get the value of current date and

Datetime type in SQL standard

2009-02-11 Thread Shyam Sarkar
Following is the BNF for datetime type in SQL 2003:: datetime type::= DATE | TIME [ left paren time precision right paren ] [ with or without time zone ] | TIMESTAMP [ left paren timestamp precision right paren ] [ with or without time zone ] Please let me know

RE: Need LOCALTIMESTAMP ?

2009-02-11 Thread Ashish Thusoo
Hi Shyam, I think HIVE-192 is about the fact that there is no support for the timestamp type in Hive (or for that matter date and datetime types). In FB we are using strings to hold this information. If you are planning to add a built in function like localtimestamp, then that should

timestamp examples in standard SQL

2009-02-11 Thread Shyam Sarkar
Some examples with timestamp in SQL standard :: == Create Table CREATE TABLE Stu_Table ( Stu_Id varchar(2), Stu_Name varchar(10), Stu_Dob timestamp NOT NULL ); Insert Date Into Stu_Table Now insert into

RE: Need LOCALTIMESTAMP ?

2009-02-11 Thread Shyam Sarkar
Hi Ashish, Read about the latest TIMESTAMP implementation in MySQL 5.0 version and suggest :: http://dev.mysql.com/doc/refman/5.0/en/timestamp.html Also please comment on the following MySQL 5.0 implementation semantics:: TIMESTAMP values are converted from the current time zone to UTC for

[jira] Updated: (HIVE-270) Add a lazy-deserialized SerDe for space and cpu efficient serialization of rows with primitive types

2009-02-11 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-270: Attachment: HIVE-270.4.patch After looking at the code again, I decided to postpone the change of

[jira] Updated: (HIVE-270) Add a lazy-deserialized SerDe for space and cpu efficient serialization of rows with primitive types

2009-02-11 Thread Zheng Shao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zheng Shao updated HIVE-270: Attachment: HIVE-270.5.patch Removed all test case changes (can be automatically generated by ant test

[jira] Updated: (HIVE-131) insert overwrite directory leaves behind uncommitted/tmp files from failed tasks

2009-02-11 Thread Joydeep Sen Sarma (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Joydeep Sen Sarma updated HIVE-131: --- Attachment: hive-131.patch.2 Dhruba said: 1. I see that execute returns values 1, 2, and 3.