[jira] [Commented] (HIVE-3581) get_json_object and json_tuple return null in the presence of new line characters

2012-10-17 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13477800#comment-13477800 ] Philip Tromans commented on HIVE-3581: -- This patch breaks hive trunk on Ha

Re: newbie in hive dev - process help

2012-09-13 Thread Philip Tromans
If you want code committed to Hive, then you need to open a JIRA and attach a patch. Cheers, Phil. On 13 September 2012 13:16, Chalcy Raja wrote: > Anybody??? > > -Original Message- > From: Chalcy Raja [mailto:chalcy.r...@careerbuilder.com] > Sent: Wednesday, September 12, 2012 9:30 AM

Re: New Issue raised in Jira

2012-08-14 Thread Philip Tromans
What you're trying to do can be achieved with: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions with a "D" in a format string. See: http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html Phil. On 14 August 2012 07:30, Deep

[jira] [Commented] (HIVE-3361) Warning printed at error level

2012-08-09 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13431706#comment-13431706 ] Philip Tromans commented on HIVE-3361: -- (apologies for the dupes, JIRA was givin

Inconsistencies around casting booleans

2012-08-09 Thread Philip Tromans
Hi all, We've been using boolean types in partition values (not the best idea, I know), and we've noticed a few inconsistencies around casting: SELECT cast('true' as boolean), cast('false' as boolean), cast(true as string), cast(false as string), cast(cast(false as string) as boolean) FROM test

Inconsistencies around casting booleans

2012-08-09 Thread Philip Tromans
Hi all, We've been using boolean types in partition values (not the best idea, I know), and we've noticed a few inconsistencies around casting: select cast('true' as boolean), cast('false' as boolean), cast(true as string), cast(false as string), cast(cast(false as string) as boolean) from test

[jira] [Commented] (HIVE-2517) Support group by on union and struct type

2012-08-03 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2517?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428152#comment-13428152 ] Philip Tromans commented on HIVE-2517: -- Hi, Can we bump this please? I just cam

[jira] [Commented] (HIVE-2843) UDAF to convert an aggregation to a map

2012-07-18 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13417144#comment-13417144 ] Philip Tromans commented on HIVE-2843: -- Hi David, I think that this would

[jira] [Updated] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-21 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-3125: - Attachment: HIVE-3125.2.patch.txt > sort_array doesn't work with LazyP

[jira] [Commented] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-21 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398277#comment-13398277 ] Philip Tromans commented on HIVE-3125: -- @Carl, @Edward: I've updated the

[jira] [Commented] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-18 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13395758#comment-13395758 ] Philip Tromans commented on HIVE-3125: -- @Carl, @Edward: Review board seems to be

[jira] [Commented] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-14 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13294921#comment-13294921 ] Philip Tromans commented on HIVE-3125: -- @Carl: reviews.apache.org appears to be

[jira] [Updated] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-13 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-3125: - Status: Patch Available (was: Open) > sort_array doesn't work with LazyP

[jira] [Updated] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-13 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-3125: - Attachment: HIVE-3125.1.patch.txt I'm not entirely sure if this is the right way to fix this

[jira] [Updated] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-13 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-3125: - Description: The sort_array function doesn't work against data that's actually c

[jira] [Created] (HIVE-3125) sort_array doesn't work with LazyPrimitive

2012-06-13 Thread Philip Tromans (JIRA)
Philip Tromans created HIVE-3125: Summary: sort_array doesn't work with LazyPrimitive Key: HIVE-3125 URL: https://issues.apache.org/jira/browse/HIVE-3125 Project: Hive Issue Type

Re: non-string partition columns

2012-05-26 Thread Philip Tromans
We're using non-string partition columns in production. I think non string partition columns are a good thing to have - it allows you to do all sorts of date range calculations etc. AFAIK, MySQL's partition columns can be of any type. Phil. On May 26, 2012 7:55 AM, "Namit Jain" wrote: > Should I

[jira] [Commented] (HIVE-2988) Use of XMLEncoder to serialize MapredWork causes OOM in hive cli

2012-04-29 Thread Philip Tromans (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13264501#comment-13264501 ] Philip Tromans commented on HIVE-2988: -- This might not be related, but I've

[jira] [Updated] (HIVE-2736) Hive UDFs cannot emit binary constants

2012-04-15 Thread Philip Tromans (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-2736: - Attachment: HIVE-2736.2.patch.txt @Ashutosh - I've added a tiny test query as well. It thro

[jira] [Updated] (HIVE-2736) Hive UDFs cannot emit binary constants

2012-04-09 Thread Philip Tromans (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-2736: - Attachment: HIVE-2736.1.patch.txt > Hive UDFs cannot emit binary consta

[jira] [Updated] (HIVE-2736) Hive UDFs cannot emit binary constants

2012-04-09 Thread Philip Tromans (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-2736: - Fix Version/s: 0.9.0 Labels: newbie (was: ) Status: Patch Available (was

Re: Hive / Hadoop Log Retrieval Problem

2012-04-02 Thread Philip Tromans
plans to update the default hadoop build? Cheers, Phil. On 6 March 2012 14:43, Philip Tromans wrote: > Hi, > > It appears that no recent version of hadoop supports this - the hadoop > code appears to have changed in 2010: > > http://svn.apache.org/viewvc/hadoop/common/trun

Re: Hive / Hadoop Log Retrieval Problem

2012-03-06 Thread Philip Tromans
someone could confirm that I'm working on the right lines then I'll open up a JIRA (or add to HIVE-1579) and submit a patch. Cheers, Phil. On 6 March 2012 14:13, Philip Tromans wrote: > Hi all, > > I'm running into a problem - I'm using Hive trunk (pretty recent, but

Hive / Hadoop Log Retrieval Problem

2012-03-06 Thread Philip Tromans
Hi all, I'm running into a problem - I'm using Hive trunk (pretty recent, but I see the bug's in trunk at time of writing as well), with Hadoop 0.20.205.0. I have a job which fails (for a reason which is entirely my own fault), and when it does fail Hive dies with the following exception: Ended J

JobDebugger bug / wrong Hadoop version

2012-03-06 Thread Philip Tromans
Hi all, I'm running into a problem - I'm using Hive trunk (pretty recent, but I see the bug's in trunk at time of writing as well), with Hadoop 0.20.205.0. I have a job which fails (for a reason which is entirely my own fault), and when it does fail Hive dies with the following exception: Ended J

[jira] [Commented] (HIVE-2752) Index names are case sensitive

2012-01-26 Thread Philip Tromans (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13193758#comment-13193758 ] Philip Tromans commented on HIVE-2752: -- I can probably fix this, but I haven'

[jira] [Created] (HIVE-2752) Index names are case sensitive

2012-01-26 Thread Philip Tromans (Created) (JIRA)
: 0.9.0 Reporter: Philip Tromans Priority: Minor The following script: DROP TABLE IF EXISTS TestTable; CREATE TABLE TestTable (a INT); DROP INDEX IF EXISTS TestTableA_IDX ON TestTable; CREATE INDEX TestTableA_IDX ON TABLE TestTable (a) AS

[jira] [Updated] (HIVE-2736) Hive UDFs cannot emit binary constants

2012-01-23 Thread Philip Tromans (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Tromans updated HIVE-2736: - Description: I recently wrote a UDF which emits BINARY values (as implemented in [HIVE-2380

[jira] [Created] (HIVE-2736) Hive UDFs cannot emit binary constants

2012-01-23 Thread Philip Tromans (Created) (JIRA)
, UDF Affects Versions: 0.9.0 Reporter: Philip Tromans Priority: Minor I recently rote a UDF which emits BINARY values (as implemented in [HIVE-2380|https://issues.apache.org/jira/browse/HIVE-2380]). When testing this, I encountered the following exception (because I