[jira] Commented: (HIVE-138) Provide option to export a HEADER

[ https://issues.apache.org/jira/browse/HIVE-138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12905335#action_12905335 ] Adam Kramer commented on HIVE-138: -- We should be able to do this easily for the first case,

[jira] Commented: (HIVE-783) Implement disjunctive JOINs

[ https://issues.apache.org/jira/browse/HIVE-783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12896331#action_12896331 ] Adam Kramer commented on HIVE-783: -- Also fails: a JOIN b ON (a.key b.key), for a perhaps

[jira] Resolved: (HIVE-165) Add standard statistical functions

[ https://issues.apache.org/jira/browse/HIVE-165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer resolved HIVE-165. -- Resolution: Fixed VAR and SD were added months ago. :) Add standard statistical functions

[jira] Resolved: (HIVE-621) Inconsistent reporting of null and delimiter across access types

[ https://issues.apache.org/jira/browse/HIVE-621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer resolved HIVE-621. -- Resolution: Fixed This is the way things work now. Unsure who fixed it. Note, however, that \N and null

[jira] Created: (HIVE-1466) Add NULL DEFINED AS to ROW FORMAT specification

Add NULL DEFINED AS to ROW FORMAT specification --- Key: HIVE-1466 URL: https://issues.apache.org/jira/browse/HIVE-1466 Project: Hadoop Hive Issue Type: Improvement Reporter: Adam

[jira] Created: (HIVE-1395) Table aliases are ambiguous

Table aliases are ambiguous --- Key: HIVE-1395 URL: https://issues.apache.org/jira/browse/HIVE-1395 Project: Hadoop Hive Issue Type: Bug Reporter: Adam Kramer Consider this query: SELECT a.num FROM (

[jira] Created: (HIVE-1334) Add PERCENTILE for continuous (double) distributions

Add PERCENTILE for continuous (double) distributions Key: HIVE-1334 URL: https://issues.apache.org/jira/browse/HIVE-1334 Project: Hadoop Hive Issue Type: New Feature Reporter:

[jira] Commented: (HIVE-446) Implement TRUNCATE

[ https://issues.apache.org/jira/browse/HIVE-446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12863193#action_12863193 ] Adam Kramer commented on HIVE-446: -- Another note: Sometimes I shut off hive.merge.mapfiles;

[jira] Created: (HIVE-1301) RAND() should be RAND_UNIF(); also, we should create RAND_NORM() and add options

RAND() should be RAND_UNIF(); also, we should create RAND_NORM() and add options Key: HIVE-1301 URL: https://issues.apache.org/jira/browse/HIVE-1301 Project: Hadoop Hive

[jira] Created: (HIVE-1263) Is it time for INSERT APPEND?

Is it time for INSERT APPEND? - Key: HIVE-1263 URL: https://issues.apache.org/jira/browse/HIVE-1263 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer It seems to me that for someone

[jira] Created: (HIVE-1251) TRANSFORM should allow pipes in some form

TRANSFORM should allow pipes in some form - Key: HIVE-1251 URL: https://issues.apache.org/jira/browse/HIVE-1251 Project: Hadoop Hive Issue Type: Improvement Reporter: Adam Kramer Many

[jira] Commented: (HIVE-801) row-wise IN would be useful

[ https://issues.apache.org/jira/browse/HIVE-801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12839052#action_12839052 ] Adam Kramer commented on HIVE-801: -- Also note that the true utility of this is syntax like

[jira] Created: (HIVE-967) Implement show create table

Implement show create table - Key: HIVE-967 URL: https://issues.apache.org/jira/browse/HIVE-967 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer SHOW CREATE TABLE would be very

[jira] Created: (HIVE-937) CONCAT UDF for GROUP BY

CONCAT UDF for GROUP BY --- Key: HIVE-937 URL: https://issues.apache.org/jira/browse/HIVE-937 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer It would be nice to have a UDF like CONCAT

[jira] Resolved: (HIVE-937) CONCAT UDF for GROUP BY

[ https://issues.apache.org/jira/browse/HIVE-937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer resolved HIVE-937. -- Resolution: Duplicate CONCAT UDF for GROUP BY --- Key: HIVE-937

[jira] Commented: (HIVE-937) CONCAT UDF for GROUP BY

[ https://issues.apache.org/jira/browse/HIVE-937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12779059#action_12779059 ] Adam Kramer commented on HIVE-937: -- Hi Namit, Where should I take a look at it? It is not

[jira] Created: (HIVE-934) Rows loaded incorrect; should be suppressed.

Rows loaded incorrect; should be suppressed. Key: HIVE-934 URL: https://issues.apache.org/jira/browse/HIVE-934 Project: Hadoop Hive Issue Type: Bug Reporter: Adam Kramer For several

[jira] Created: (HIVE-871) UNION ALL schema errors are incorrect in multiple unions

UNION ALL schema errors are incorrect in multiple unions Key: HIVE-871 URL: https://issues.apache.org/jira/browse/HIVE-871 Project: Hadoop Hive Issue Type: Bug Reporter:

[jira] Created: (HIVE-835) Make MAP and REDUCE work as expected or add warnings

Make MAP and REDUCE work as expected or add warnings Key: HIVE-835 URL: https://issues.apache.org/jira/browse/HIVE-835 Project: Hadoop Hive Issue Type: Improvement Reporter:

[jira] Created: (HIVE-836) Add syntax to force a new mapreduce job / transform subquery in mapper

Add syntax to force a new mapreduce job / transform subquery in mapper -- Key: HIVE-836 URL: https://issues.apache.org/jira/browse/HIVE-836 Project: Hadoop Hive Issue Type:

[jira] Commented: (HIVE-832) Disallow OUTER JOIN with partition in WHERE clause in strict mode

[ https://issues.apache.org/jira/browse/HIVE-832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12755636#action_12755636 ] Adam Kramer commented on HIVE-832: -- I think if that's going on (seems like a valid use case

[jira] Created: (HIVE-832) Disallow OUTER JOIN with partition in WHERE clause in strict mode

Disallow OUTER JOIN with partition in WHERE clause in strict mode - Key: HIVE-832 URL: https://issues.apache.org/jira/browse/HIVE-832 Project: Hadoop Hive Issue Type: Wish

[jira] Created: (HIVE-825) Better error messages regarding partitions and union all?

Better error messages regarding partitions and union all? - Key: HIVE-825 URL: https://issues.apache.org/jira/browse/HIVE-825 Project: Hadoop Hive Issue Type: Improvement

[jira] Created: (HIVE-801) row-wise IN would be useful

row-wise IN would be useful --- Key: HIVE-801 URL: https://issues.apache.org/jira/browse/HIVE-801 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer SELECT * FROM tablename t WHERE

[jira] Commented: (HIVE-801) row-wise IN would be useful

[ https://issues.apache.org/jira/browse/HIVE-801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12748188#action_12748188 ] Adam Kramer commented on HIVE-801: -- Using UNION ALL doesn't do the same as a disjunctive

[jira] Created: (HIVE-783) Implement disjunctive JOINs

Implement disjunctive JOINs Key: HIVE-783 URL: https://issues.apache.org/jira/browse/HIVE-783 Project: Hadoop Hive Issue Type: New Feature Reporter: Adam Kramer Currently, Hive does not allow

[jira] Created: (HIVE-754) Include tt tag in hive.query.string when sending to the jobtracker

Include tt tag in hive.query.string when sending to the jobtracker Key: HIVE-754 URL: https://issues.apache.org/jira/browse/HIVE-754 Project: Hadoop Hive Issue Type:

[jira] Updated: (HIVE-431) Auto-add table property select to be the select statement that created the table

[ https://issues.apache.org/jira/browse/HIVE-431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-431: - Description: A syntactic copy of the query that was used to fill a table would often be AMAZINGLY useful

[jira] Commented: (HIVE-431) Auto-add table property select to be the select statement that created the table

[ https://issues.apache.org/jira/browse/HIVE-431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12740329#action_12740329 ] Adam Kramer commented on HIVE-431: -- Another note: This isn't done or represented in normal

[jira] Created: (HIVE-657) .hiverc would be nice

.hiverc would be nice - Key: HIVE-657 URL: https://issues.apache.org/jira/browse/HIVE-657 Project: Hadoop Hive Issue Type: Improvement Reporter: Adam Kramer It would be great if the hive CLI would execute

[jira] Commented: (HIVE-243) ^C breaks out of running query, but not whole CLI

[ https://issues.apache.org/jira/browse/HIVE-243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12732825#action_12732825 ] Adam Kramer commented on HIVE-243: -- A lot of scripts are currently being used to extend the

[jira] Commented: (HIVE-243) ^C breaks out of running query, but not whole CLI

[ https://issues.apache.org/jira/browse/HIVE-243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12732827#action_12732827 ] Adam Kramer commented on HIVE-243: -- Also also, ^C when a query is half-entered should cancel

[jira] Commented: (HIVE-588) LIMIT n is slower than it needs to be

[ https://issues.apache.org/jira/browse/HIVE-588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12731263#action_12731263 ] Adam Kramer commented on HIVE-588: -- This is because * allows you to output whole rows at a

[jira] Commented: (HIVE-478) Surface processor time for queries

[ https://issues.apache.org/jira/browse/HIVE-478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12729787#action_12729787 ] Adam Kramer commented on HIVE-478: -- Also, in case it was not obvious, the current system

[jira] Created: (HIVE-621) Inconsistent reporting of null and delimiter across access types

Inconsistent reporting of null and delimiter across access types -- Key: HIVE-621 URL: https://issues.apache.org/jira/browse/HIVE-621 Project: Hadoop Hive Issue Type: Wish

[jira] Commented: (HIVE-621) Inconsistent reporting of null and delimiter across access types

[ https://issues.apache.org/jira/browse/HIVE-621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12729376#action_12729376 ] Adam Kramer commented on HIVE-621: -- Actually, this behavior appears to have just changed

[jira] Created: (HIVE-602) INSERT LOCAL PIPE '/path/to/program' would be lovely

INSERT LOCAL PIPE '/path/to/program' would be lovely Key: HIVE-602 URL: https://issues.apache.org/jira/browse/HIVE-602 Project: Hadoop Hive Issue Type: New Feature Components:

[jira] Created: (HIVE-588) LIMIT n is slower than it needs to be

LIMIT n is slower than it needs to be - Key: HIVE-588 URL: https://issues.apache.org/jira/browse/HIVE-588 Project: Hadoop Hive Issue Type: Improvement Reporter: Adam Kramer SELECT a FROM t

[jira] Created: (HIVE-549) UNION ALL statements should be run in parallel

UNION ALL statements should be run in parallel -- Key: HIVE-549 URL: https://issues.apache.org/jira/browse/HIVE-549 Project: Hadoop Hive Issue Type: Wish Components: Query Processor

[jira] Updated: (HIVE-549) UNION ALL statements should be run in parallel

[ https://issues.apache.org/jira/browse/HIVE-549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-549: - Description: In a massively parallel database system, it would be awesome to also parallelize some of the

[jira] Commented: (HIVE-315) remove map() and reduce()

[ https://issues.apache.org/jira/browse/HIVE-315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12714245#action_12714245 ] Adam Kramer commented on HIVE-315: -- Another option is to actually fix them to ensure

[jira] Created: (HIVE-494) Select columns by number instead of name

Select columns by number instead of name Key: HIVE-494 URL: https://issues.apache.org/jira/browse/HIVE-494 Project: Hadoop Hive Issue Type: Wish Components: Clients, Query Processor

[jira] Created: (HIVE-491) Comments and ALTER TABLE

Comments and ALTER TABLE Key: HIVE-491 URL: https://issues.apache.org/jira/browse/HIVE-491 Project: Hadoop Hive Issue Type: Improvement Components: Clients, Documentation, Metastore, Query Processor

[jira] Created: (HIVE-478) Surface processor time for queries

Surface processor time for queries Key: HIVE-478 URL: https://issues.apache.org/jira/browse/HIVE-478 Project: Hadoop Hive Issue Type: Wish Components: Logging, Query Processor

[jira] Created: (HIVE-431) Add generating query as a table property

Add generating query as a table property -- Key: HIVE-431 URL: https://issues.apache.org/jira/browse/HIVE-431 Project: Hadoop Hive Issue Type: Wish Reporter: Adam Kramer It would be

[jira] Updated: (HIVE-430) Ability to comment desired for hive query files

[ https://issues.apache.org/jira/browse/HIVE-430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-430: - Description: It is, in many cases, quite useful to write a query, save it in a file, and run the file

[jira] Created: (HIVE-430) Ability to comment desired for hive query files

Ability to comment desired for hive query files --- Key: HIVE-430 URL: https://issues.apache.org/jira/browse/HIVE-430 Project: Hadoop Hive Issue Type: Wish Components: Clients, Query

[jira] Created: (HIVE-362) avg() returns null if any item in the list is null; create function that doesn't

avg() returns null if any item in the list is null; create function that doesn't Key: HIVE-362 URL: https://issues.apache.org/jira/browse/HIVE-362 Project: Hadoop Hive

[jira] Created: (HIVE-254) Tracker page should provide a link to the next step

Tracker page should provide a link to the next step - Key: HIVE-254 URL: https://issues.apache.org/jira/browse/HIVE-254 Project: Hadoop Hive Issue Type: Wish Components: Web UI

[jira] Created: (HIVE-178) SELECT without FROM; dropping unnecessary table references

SELECT without FROM; dropping unnecessary table references -- Key: HIVE-178 URL: https://issues.apache.org/jira/browse/HIVE-178 Project: Hadoop Hive Issue Type: Improvement

[jira] Updated: (HIVE-178) SELECT without FROM; dropping unnecessary table references

[ https://issues.apache.org/jira/browse/HIVE-178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-178: - Description: SELECT 1+1; should just return '2', but instead hive fails because no table is listed.

[jira] Commented: (HIVE-31) Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy

[ https://issues.apache.org/jira/browse/HIVE-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12655579#action_12655579 ] Adam Kramer commented on HIVE-31: - Similar request would be a straightforward LIKE command:

[jira] Created: (HIVE-165) var(col) built-in to go with avg(col) and count(col)

var(col) built-in to go with avg(col) and count(col) Key: HIVE-165 URL: https://issues.apache.org/jira/browse/HIVE-165 Project: Hadoop Hive Issue Type: Wish Reporter: Adam

[jira] Commented: (HIVE-105) estimate number of required reducers and other map-reduce parameters automatically

[ https://issues.apache.org/jira/browse/HIVE-105?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12655904#action_12655904 ] Adam Kramer commented on HIVE-105: -- It seems to me that n00b hive users (like I was, and

[jira] Updated: (HIVE-165) var(col) built-in to go with avg(col) and count(col)

[ https://issues.apache.org/jira/browse/HIVE-165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Adam Kramer updated HIVE-165: - Description: The last step in the unholy triumvirate of statistical built-ins is the variance. We already

[jira] Created: (HIVE-138) Provide option to export a HEADER

Provide option to export a HEADER - Key: HIVE-138 URL: https://issues.apache.org/jira/browse/HIVE-138 Project: Hadoop Hive Issue Type: Improvement Components: Clients, Query Processor