Hi Jamal,
Check if the function really returns what it should and that your data are
really in MMdd format. You can do this by simple query like this:
SELECT dt, yesterdaydate('MMdd') FROM REALTIME LIMIT 1;
I don't see anything wrong with the function itself, it works well for me
[
https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-3268:
-
Status: Patch Available (was: Open)
comments addressed, latest patch attached
[
https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-3268:
-
Attachment: hive.3268.2.patch
expressions in cluster by are not working
I tested that function using main and by printing it out and it works fine.
As I am trying to get the Yesterday's date.
I need my query to be like this as today's date is Aug 6th, so query should
be for Aug 5th. And this works fine for me.
*SELECT * FROM REALTIME where dt= '20120805' LIMIT 10;*
Namit Jain created HIVE-3339:
Summary: Change the rules in SemanticAnalyzer to use
Operator.getName() instead of hardcoded names
Key: HIVE-3339
URL: https://issues.apache.org/jira/browse/HIVE-3339
[
https://issues.apache.org/jira/browse/HIVE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Worms updated HIVE-2843:
--
Affects Version/s: 0.10.0
Status: Patch Available (was: Open)
UDAF to convert an
[
https://issues.apache.org/jira/browse/HIVE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Worms updated HIVE-2843:
--
Attachment: HIVE-2843.1.patch.txt
UDAF to convert an aggregation to a map
[
https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ajesh Kumar updated HIVE-3141:
--
Attachment: HIVE-3141.1.patch.txt
Made change in CliDriver.java to make a check on the syntax of select
[
https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ajesh Kumar updated HIVE-3141:
--
Labels: patch (was: )
Affects Version/s: 0.9.0
Status: Patch Available
So, the patch doesn not seem to fix the problem we are having, but it
combined with the one I sent to the list seems to take care of it. I
will continue to study this issue and report back on any issues.
Thanks again!
On 08/06/2012 06:59 PM, Stephen Scaffid wrote:
Thanks! I'll see how it
See
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/99/
--
[...truncated 10205 lines...]
[echo] Project: odbc
[copy] Warning:
https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/odbc/src/conf
[
https://issues.apache.org/jira/browse/HIVE-967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Feng Lu updated HIVE-967:
-
Attachment: HIVE-967.3.patch.txt
The diff is updated and a current patch is attached here.
Hi Jan,
I figured that out, it is working fine for me now. The only question I have
is, if I am doing like this-
SELECT * FROM REALTIME where dt= yesterdaydate('MMdd') LIMIT 10;
Then the above query will be evaluated as below right?
SELECT * FROM REALTIME where dt= ‘20120806’ LIMIT
Try
ALTER TABLE table SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igor
decide.com
On Mon, Aug 6, 2012 at 11:08 PM, Babe Ruth gtevelde-h...@hotmail.comwrote:
Hello,
I created a managed table in HIVE when i intended for it to be external,
is it possible for me to change the
Have you tried using EXPLAIN[1] on your query? I usually like to use that
to get a better understanding of what my query is actually doing and
debugging at other times.
[1] https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain
On Tue, Aug 7, 2012 at 12:20 PM, Raihan Jamal
I'm afraid that he query
SELECT * FROM REALTIME where dt= yesterdaydate('MMdd') LIMIT 10;
will scan entire table, because the functions is evaluated at runtime, so
Hive doesn't know what the value is when it decides which files to scan. I
am not 100% sure though, you should try it.
Also,
Oops, sorry I made a copypaste mistake :) The annotation should read
@*UDFType(deterministic=true*)
Jan
On Tue, Aug 7, 2012 at 7:37 PM, Jan Dolinár dolik@gmail.com wrote:
I'm afraid that he query
SELECT * FROM REALTIME where dt= yesterdaydate('MMdd') LIMIT 10;
will scan entire
I am not sure about the data, but when we do
SELECT count(*) from data_realtime where dt='20120730' and uid is null
I get the count
but If I do-
SELECT * from data_realtime where dt='20120730' and uid is null
I get zero record back. But if all the record is NULL then I should be
getting NULL
I am running Hive 0.6.
On Tue, Aug 7, 2012 at 11:04 AM, kulkarni.swar...@gmail.com
kulkarni.swar...@gmail.com wrote:
What is the hive version that you are using?
On Tue, Aug 7, 2012 at 12:57 PM, Techy Teck comptechge...@gmail.comwrote:
I am not sure about the data, but when we do
Hi Jan,
I have date in different format also, so that is the reason I was thinking
to do by this approach. How can I make sure this will work on the selected
partition only and it will not scan the entire table. I will add your
suggestion in my UDF as deterministic thing.
My simple question here
In that case you might want to try count(1) instead of count(*) and see
if that makes any difference. [1]
[1] https://issues.apache.org/jira/browse/HIVE-287
On Tue, Aug 7, 2012 at 1:07 PM, Techy Teck comptechge...@gmail.com wrote:
I am running Hive 0.6.
On Tue, Aug 7, 2012 at 11:04 AM,
Giridharan Kesavan created HIVE-3340:
Summary: shims unit test failures fails further test progress
Key: HIVE-3340
URL: https://issues.apache.org/jira/browse/HIVE-3340
Project: Hive
[
https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bhushan Mandhani updated HIVE-3337:
---
Attachment: HIVE-3337.1.patch.txt
Create Table Like should copy configured Table
[
https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bhushan Mandhani updated HIVE-3337:
---
Labels: configuration (was: )
Status: Patch Available (was: Open)
Submitting patch
Let me try that and I will update on this thread If I found something
interesting.
Thanks for the help kulkarni.
On Tue, Aug 7, 2012 at 11:10 AM, kulkarni.swar...@gmail.com
kulkarni.swar...@gmail.com wrote:
In that case you might want to try count(1) instead of count(*) and see
if that
[
https://issues.apache.org/jira/browse/HIVE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Giridharan Kesavan updated HIVE-3340:
-
Attachment: HIVE-3340.patch
shims unit test failures fails further test progress
[
https://issues.apache.org/jira/browse/HIVE-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Giridharan Kesavan updated HIVE-3340:
-
Status: Patch Available (was: Open)
shims unit test failures fails further test
Sushanth Sowmyan created HIVE-3341:
--
Summary: Making hive tests run against different MR versions
Key: HIVE-3341
URL: https://issues.apache.org/jira/browse/HIVE-3341
Project: Hive
Issue
[
https://issues.apache.org/jira/browse/HIVE-3337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430602#comment-13430602
]
Carl Steinbach commented on HIVE-3337:
--
+1. Will commit if tests pass.
Are you running via console? The default logging level is WARN.
$HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console
This should print the INFO messages onto the console.
On Tue, Aug 7, 2012 at 4:07 PM, Ablimit Aji abli...@gmail.com wrote:
Hi,
I have put some LOG.info() statements
That's what I'm using right now. It was totally functional in
SymenticAnalyzer, but not working properly for JOIN.
On Tue, Aug 7, 2012 at 5:28 PM, kulkarni.swar...@gmail.com
kulkarni.swar...@gmail.com wrote:
Are you running via console? The default logging level is WARN.
$HIVE_HOME/bin/hive
Thanks Igor! It worked!
Date: Mon, 6 Aug 2012 23:26:04 -0700
Subject: Re: Changing table types from managed to external
From: i...@decide.com
To: u...@hive.apache.org
CC: dev@hive.apache.org
TryALTER TABLE table SET TBLPROPERTIES('EXTERNAL'='TRUE');
It worked for me.
igordecide.com
On
[
https://issues.apache.org/jira/browse/HIVE-3341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430651#comment-13430651
]
Sushanth Sowmyan commented on HIVE-3341:
Phabricator review request posted at :
[
https://issues.apache.org/jira/browse/HIVE-3341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sushanth Sowmyan updated HIVE-3341:
---
Status: Patch Available (was: Open)
Making hive tests run against different MR versions
Changes for Build #1596
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:
Gang Tim Liu created HIVE-3342:
--
Summary: Hive: Query misaligned result for Group by followed by
Join with filter and skip a group-by result
Key: HIVE-3342
URL: https://issues.apache.org/jira/browse/HIVE-3342
Gang Tim Liu created HIVE-3343:
--
Summary: Hive: Query misaligned result for Group by followed by
Join with filter and skip a group-by result
Key: HIVE-3343
URL: https://issues.apache.org/jira/browse/HIVE-3343
[
https://issues.apache.org/jira/browse/HIVE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430757#comment-13430757
]
Gang Tim Liu commented on HIVE-3343:
If we remove b.k1 5, it will generate right
[
https://issues.apache.org/jira/browse/HIVE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430761#comment-13430761
]
Gang Tim Liu commented on HIVE-3343:
root-cause is ColumnPrunerFilterProc doesn't
[
https://issues.apache.org/jira/browse/HIVE-2468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430881#comment-13430881
]
Namit Jain commented on HIVE-2468:
--
@Carl: can the above be used to compile hive source
I was trying to add a test case which only works for hadoop 23.
However, I got some errors when I tried to compile:
I tried the following:
ant -Dhadoop.version=0.23.0 -Dhadoop.security.version=0.23.0
-Dhadoop.security.version.prefix=0.23 package
ant -Dhadoop.version=0.23.0 package
looking
[
https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Namit Jain updated HIVE-3141:
-
Status: Open (was: Patch Available)
Bug in SELECT query
---
Key:
[
https://issues.apache.org/jira/browse/HIVE-3141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13430885#comment-13430885
]
Namit Jain commented on HIVE-3141:
--
Can you add negative test for the scenarios you
43 matches
Mail list logo