Hello all,
I am trying to check age in hive.
select * from tbl_name where datediff(date,dob)/365 >= 18;
Is it right to check date condition in hive?
Or do I need to do something else.
Pls suggest me as soon as possible
--
Thanks and Regards,
Bhavesh Shah
[
https://issues.apache.org/jira/browse/HIVE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thiruvel Thirumoolan updated HIVE-2913:
---
Status: Patch Available (was: Open)
> BlockMergeTask Doesn't Honor Job Configurat
Hive Dynamic Partition Insert - move task not considering
'hive.exec.max.dynamic.partitions' from CLI
-
Key: HIVE-2918
URL: https://issues.apache.org/jira/browse/H
[
https://issues.apache.org/jira/browse/HIVE-2881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244141#comment-13244141
]
Hudson commented on HIVE-2881:
--
Integrated in Hive-trunk-h0.21 #1346 (See
[https://builds.apa
[
https://issues.apache.org/jira/browse/HIVE-2805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-2805:
-
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committe
[
https://issues.apache.org/jira/browse/HIVE-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-2853:
-
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committe
[
https://issues.apache.org/jira/browse/HIVE-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-2801:
-
Assignee: binlijin
Status: Open (was: Patch Available)
Please make it 'Patch Available' after addre
[
https://issues.apache.org/jira/browse/HIVE-2863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244284#comment-13244284
]
Phabricator commented on HIVE-2863:
---
njain has accepted the revision "HIVE-2863 [jira] Am
Duplicated Hadoop Package Structure in Hive exec
Key: HIVE-2919
URL: https://issues.apache.org/jira/browse/HIVE-2919
Project: Hive
Issue Type: Bug
Components: Shims
Affects Versi
[
https://issues.apache.org/jira/browse/HIVE-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Buddhika Chamith De Alwis updated HIVE-2919:
Issue Type: Improvement (was: Bug)
> Duplicated Hadoop Package Structur
[
https://issues.apache.org/jira/browse/HIVE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kevin Wilfong resolved HIVE-2908.
-
Resolution: Fixed
Committed. Thanks, Sambavi.
> Hive: Extend ALTER TABLE DROP PA
[
https://issues.apache.org/jira/browse/HIVE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kevin Wilfong updated HIVE-2908:
Affects Version/s: 0.9.0
> Hive: Extend ALTER TABLE DROP PARTITION syntax to use all comparators
I was just trying to build a patch for this, to submit against
https://issues.apache.org/jira/browse/HIVE-1579 and it seems that the
default hadoop build is 0.20.1, which has a different set of
parameters required in the Hadoop TaskLogServlet to a more recent
version, like 0.20.205. Are there any p
[
https://issues.apache.org/jira/browse/HIVE-2822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2822:
--
Attachment: HIVE-2822.D2475.2.patch
ctdean updated the revision "HIVE-2822 [jira] Add JSON output to the
[
https://issues.apache.org/jira/browse/HIVE-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2711:
--
Attachment: HIVE-2711.D2571.1.patch
omalley requested code review of "HIVE-2711 [jira] Make the header o
[
https://issues.apache.org/jira/browse/HIVE-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244404#comment-13244404
]
Phabricator commented on HIVE-2711:
---
omalley has abandoned the revision "HIVE-2711 [jira]
[
https://issues.apache.org/jira/browse/HIVE-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2711:
--
Attachment: HIVE-2711.D2115.2.patch
omalley updated the revision "HIVE-2711 [jira] Make the header of RC
TestStatsPublisherEnhanced throws NPE on JDBC connection failure
Key: HIVE-2920
URL: https://issues.apache.org/jira/browse/HIVE-2920
Project: Hive
Issue Type: Bug
Com
[
https://issues.apache.org/jira/browse/HIVE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244501#comment-13244501
]
Carl Steinbach commented on HIVE-2920:
--
I have seen intermittent failures in TestStats
[
https://issues.apache.org/jira/browse/HIVE-2822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244556#comment-13244556
]
Phabricator commented on HIVE-2822:
---
ashutoshc has requested changes to the revision "HIV
[
https://issues.apache.org/jira/browse/HIVE-2805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244633#comment-13244633
]
Hudson commented on HIVE-2805:
--
Integrated in Hive-trunk-h0.21 #1347 (See
[https://builds.apa
[
https://issues.apache.org/jira/browse/HIVE-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244632#comment-13244632
]
Hudson commented on HIVE-2853:
--
Integrated in Hive-trunk-h0.21 #1347 (See
[https://builds.apa
[
https://issues.apache.org/jira/browse/HIVE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2920:
--
Attachment: HIVE-2920.D2577.1.patch
cwsteinbach requested code review of "HIVE-2920 [jira]
TestStatsPub
StatsPublisher and StatsAggregator interfaces should throw exceptions
-
Key: HIVE-2921
URL: https://issues.apache.org/jira/browse/HIVE-2921
Project: Hive
Issue Type: Bug
[
https://issues.apache.org/jira/browse/HIVE-2921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244650#comment-13244650
]
Carl Steinbach commented on HIVE-2921:
--
Currently all of the methods in the StatsAggre
[
https://issues.apache.org/jira/browse/HIVE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2920:
-
Attachment: HIVE-2920.D2577.1.patch
> TestStatsPublisherEnhanced throws NPE on JDBC connection
[
https://issues.apache.org/jira/browse/HIVE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2920:
-
Release Note:
Status: Patch Available (was: Open)
This patch moves the StatsAggregat
Changes for Build #241
1 tests failed.
REGRESSION:
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_script_broken_pipe1
Error Message:
Unexpected exception
See build/ql/tmp/hive.log, or try "ant test ... -Dtest.silent=false" to get
more logs.
Stack Trace:
junit.framewo
[
https://issues.apache.org/jira/browse/HIVE-2185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2185:
-
Release Note: This patch added getSerDeStats() methods to the Serializer
and Deserializer interfac
[
https://issues.apache.org/jira/browse/HIVE-2822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244740#comment-13244740
]
Chris Dean commented on HIVE-2822:
--
Not sure what happened with the .q.out files. I'll ro
[
https://issues.apache.org/jira/browse/HIVE-2504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244756#comment-13244756
]
Rohini Palaniswamy commented on HIVE-2504:
--
Haven't gotten any response on this fo
[
https://issues.apache.org/jira/browse/HIVE-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2848:
--
Attachment: HIVE-2848.D2313.3.patch
navis updated the revision "HIVE-2848 [jira] Add validation to HiveC
PartitionSpec should have a API for getting partition filter string instead of
using toString()
---
Key: HIVE-2922
URL: https://issues.apache.org/jira/browse/HIVE-2922
[
https://issues.apache.org/jira/browse/HIVE-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244876#comment-13244876
]
Phabricator commented on HIVE-2920:
---
zhenxiao has commented on the revision "HIVE-2920 [j
[
https://issues.apache.org/jira/browse/HIVE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lei Zhao updated HIVE-2530:
---
Assignee: Lei Zhao
> Implement SHOW TBLPROPERTIES
>
>
> Key:
testAclPositive in TestZooKeeperTokenStore failing in clean checkout when run
on Mac
Key: HIVE-2923
URL: https://issues.apache.org/jira/browse/HIVE-2923
Project: Hiv
[
https://issues.apache.org/jira/browse/HIVE-2902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244880#comment-13244880
]
Mahsa Mofidpoor commented on HIVE-2902:
---
then there should be no problem with removin
[
https://issues.apache.org/jira/browse/HIVE-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244895#comment-13244895
]
Ashutosh Chauhan commented on HIVE-2585:
{code}
BUILD SUCCESSFUL
Total time: 339 mi
[
https://issues.apache.org/jira/browse/HIVE-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2585:
---
Status: Patch Available (was: Open)
> Collapse hive.metastore.uris and hive.metastore.loc
Hi all,
Branch for 0.8-r2 was created on Dec 7, almost four months ago. Between
then and now lots of cool stuff has landed in trunk waiting to be released
and get to users. I think its a good time now to get the ball rolling for
0.9 release. If this sounds good, I would propose to cut a branch f
I'm +1 on doing an 0.9.0 release, but would also like to suggest that we
put together a list of 0.9.0 blockers before cutting the release branch. In
the past we have frequently underestimated the amount of work required to
get trunk into a releasable state, with the consequence that we up wasting
t
[
https://issues.apache.org/jira/browse/HIVE-2853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2853:
---
Fix Version/s: 0.9.0
> Add pre event listeners to metastore
>
[
https://issues.apache.org/jira/browse/HIVE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2908:
---
Fix Version/s: 0.9.0
> Hive: Extend ALTER TABLE DROP PARTITION syntax to use all comparato
[
https://issues.apache.org/jira/browse/HIVE-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244909#comment-13244909
]
Ashutosh Chauhan commented on HIVE-2860:
Latest patch results in 5 failed tests in
[
https://issues.apache.org/jira/browse/HIVE-2881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2881:
---
Fix Version/s: 0.9.0
> Remove redundant key comparing in SMBMapJoinOperator
>
[
https://issues.apache.org/jira/browse/HIVE-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244912#comment-13244912
]
Carl Steinbach commented on HIVE-2860:
--
@Ashutosh: Which tests failed?
[
https://issues.apache.org/jira/browse/HIVE-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Weise updated HIVE-2646:
---
Fix Version/s: 0.9.0
> Hive Ivy dependencies on Hadoop should depend on jars directly, not tarball
Here is a list of jiras which I plan to get in 0.9.
HIVE-2084
HIVE-2822
HIVE-2764
HIVE-538
I will work with authors of these patches to see these can get in. Others,
please feel free to add this list.
Thanks,
Ashutosh
On Mon, Apr 2, 2012 at 18:39, Carl Steinbach wrote:
> I'm +1 on doing an 0.
[
https://issues.apache.org/jira/browse/HIVE-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-2585:
-
Status: Open (was: Patch Available)
> Collapse hive.metastore.uris and hive.metastore.local
>
[
https://issues.apache.org/jira/browse/HIVE-2585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244916#comment-13244916
]
Phabricator commented on HIVE-2585:
---
cwsteinbach has requested changes to the revision "H
Would be great to get HIVE-2646 included.
Thanks,
Thomas
On 4/2/12 6:59 PM, "Ashutosh Chauhan" wrote:
> Here is a list of jiras which I plan to get in 0.9.
>
> HIVE-2084
> HIVE-2822
> HIVE-2764
> HIVE-538
>
> I will work with authors of these patches to see these can get in. Others,
> please
[
https://issues.apache.org/jira/browse/HIVE-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244919#comment-13244919
]
Ashutosh Chauhan commented on HIVE-2860:
* external1.q
* external2.q
* fetchtask_io
[
https://issues.apache.org/jira/browse/HIVE-2741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thomas Weise updated HIVE-2741:
---
Fix Version/s: 0.9.0
Requires build against 0.23.1
> Single binary built against 0.2
[
https://issues.apache.org/jira/browse/HIVE-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2866:
---
Fix Version/s: 0.9.0
> Cache local map reduce job errors for additional logging
>
[
https://issues.apache.org/jira/browse/HIVE-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2676:
---
Fix Version/s: 0.9.0
> The row count that loaded to a table may not right
> ---
[
https://issues.apache.org/jira/browse/HIVE-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan reassigned HIVE-2676:
--
Assignee: binlijin
> The row count that loaded to a table may not right
> ---
[
https://issues.apache.org/jira/browse/HIVE-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2875:
---
Fix Version/s: 0.9.0
> Renaming partition changes partition location prefix
>
[
https://issues.apache.org/jira/browse/HIVE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244924#comment-13244924
]
Hudson commented on HIVE-2908:
--
Integrated in Hive-trunk-h0.21 #1348 (See
[https://builds.apa
[
https://issues.apache.org/jira/browse/HIVE-2767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2767:
---
Status: Open (was: Patch Available)
Patch needs to be rebased.
> Optionally
[
https://issues.apache.org/jira/browse/HIVE-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2332:
---
Status: Open (was: Patch Available)
Canceling patch as it first needs to address Namit's comm
[
https://issues.apache.org/jira/browse/HIVE-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244945#comment-13244945
]
Navis commented on HIVE-2332:
-
It's already on phabricator by Namit.
> If all
[
https://issues.apache.org/jira/browse/HIVE-2861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244950#comment-13244950
]
Phabricator commented on HIVE-2861:
---
ashutoshc has accepted the revision "HIVE-2861 [jira
[
https://issues.apache.org/jira/browse/HIVE-2332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2332:
---
Status: Patch Available (was: Open)
Oh, I missed it. Marking Patch Available then.
[
https://issues.apache.org/jira/browse/HIVE-2738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244954#comment-13244954
]
Ashutosh Chauhan commented on HIVE-2738:
+1 will commit if tests pass.
[
https://issues.apache.org/jira/browse/HIVE-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-2576:
---
Status: Open (was: Patch Available)
> HiveDataSource doesn't get a proper connection
> --
[
https://issues.apache.org/jira/browse/HIVE-2576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244958#comment-13244958
]
Ashutosh Chauhan commented on HIVE-2576:
@Nicolas,
Patch looks good. Instead of har
[
https://issues.apache.org/jira/browse/HIVE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244971#comment-13244971
]
Amareshwari Sriramadasu commented on HIVE-2913:
---
+1. Running tests. Will comm
[
https://issues.apache.org/jira/browse/HIVE-2913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244973#comment-13244973
]
Phabricator commented on HIVE-2913:
---
amareshwarisr has accepted the revision "HIVE-2913 [
[
https://issues.apache.org/jira/browse/HIVE-2711?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244981#comment-13244981
]
Ashutosh Chauhan commented on HIVE-2711:
Patch results failures in TestCliDriver in
[
https://issues.apache.org/jira/browse/HIVE-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13244989#comment-13244989
]
Phabricator commented on HIVE-2848:
---
njain has commented on the revision "HIVE-2848 [jira
[
https://issues.apache.org/jira/browse/HIVE-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13245000#comment-13245000
]
Phabricator commented on HIVE-2848:
---
navis has commented on the revision "HIVE-2848 [jira
[
https://issues.apache.org/jira/browse/HIVE-2848?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2848:
--
Attachment: HIVE-2848.D2313.4.patch
navis updated the revision "HIVE-2848 [jira] Add validation to HiveC
72 matches
Mail list logo