[jira] [Created] (HIVE-14345) Beeline result table has erroneous characters
Jeremy Beard created HIVE-14345: --- Summary: Beeline result table has erroneous characters Key: HIVE-14345 URL: https://issues.apache.org/jira/browse/HIVE-14345 Project: Hive Issue Type: Bug Components: Beeline Affects Versions: 1.1.0 Reporter: Jeremy Beard Priority: Minor Beeline returns query results with erroneous characters. For example: {code} 0: jdbc:hive2://:1/def> select 10; +--+--+ | _c0 | +--+--+ | 10 | +--+--+ 1 row selected (3.207 seconds) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-12721) Add UUID built in function
Jeremy Beard created HIVE-12721: --- Summary: Add UUID built in function Key: HIVE-12721 URL: https://issues.apache.org/jira/browse/HIVE-12721 Project: Hive Issue Type: Improvement Components: UDF Reporter: Jeremy Beard Assignee: Jeremy Beard A UUID function would be very useful for ETL jobs that need to generate surrogate keys. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-12468) Support multiple subquery expressions in WHERE clause
Jeremy Beard created HIVE-12468: --- Summary: Support multiple subquery expressions in WHERE clause Key: HIVE-12468 URL: https://issues.apache.org/jira/browse/HIVE-12468 Project: Hive Issue Type: Improvement Components: SQL Affects Versions: 1.1.0 Reporter: Jeremy Beard Assignee: Alan Gates HIVE-784 introduced uncorrelated subqueries in the WHERE clause. The design document on that JIRA includes restriction 8.m "We allow only 1 SubQuery expression per Query". This restriction should be removed. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-12177) Support "CREATE OR ALTER VIEW" syntax
Jeremy Beard created HIVE-12177: --- Summary: Support "CREATE OR ALTER VIEW" syntax Key: HIVE-12177 URL: https://issues.apache.org/jira/browse/HIVE-12177 Project: Hive Issue Type: New Feature Reporter: Jeremy Beard Priority: Minor -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-10027) Use descriptions from Avro schema files in column comments
Jeremy Beard created HIVE-10027: --- Summary: Use descriptions from Avro schema files in column comments Key: HIVE-10027 URL: https://issues.apache.org/jira/browse/HIVE-10027 Project: Hive Issue Type: Improvement Components: Metastore Affects Versions: 0.13.1 Reporter: Jeremy Beard Priority: Minor Avro schema files can include field descriptions using the doc tag. It would be helpful if the Hive metastore would use these descriptions as the comments for a field when the table is backed by such a schema file, instead of the default from deserializer. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-9968) Hive DDL docs don't include partitioned views
Jeremy Beard created HIVE-9968: -- Summary: Hive DDL docs don't include partitioned views Key: HIVE-9968 URL: https://issues.apache.org/jira/browse/HIVE-9968 Project: Hive Issue Type: Bug Components: Documentation Affects Versions: 1.0.0, 0.8.0 Reporter: Jeremy Beard Partitioned views have been in Hive for over four years, but the Hive DDL syntax in the documentation doesn't mention it (!). - https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/Drop/AlterView - https://cwiki.apache.org/confluence/display/Hive/PartitionedViews - https://issues.apache.org/jira/browse/HIVE-1941 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-8472) Add ALTER DATABASE SET LOCATION
Jeremy Beard created HIVE-8472: -- Summary: Add ALTER DATABASE SET LOCATION Key: HIVE-8472 URL: https://issues.apache.org/jira/browse/HIVE-8472 Project: Hive Issue Type: Improvement Components: Database/Schema Affects Versions: 0.13.1 Reporter: Jeremy Beard Similarly to ALTER TABLE tablename SET LOCATION, it would be helpful if there was an equivalent for databases. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (HIVE-8473) Support exit; in Beeline
Jeremy Beard created HIVE-8473: -- Summary: Support exit; in Beeline Key: HIVE-8473 URL: https://issues.apache.org/jira/browse/HIVE-8473 Project: Hive Issue Type: Improvement Components: CLI Affects Versions: 0.13.1 Reporter: Jeremy Beard A reasonable and unambiguous user command attempt in Beeline is exit;. We have other commands that are similarly formed, like show tables;. We should support exit; as an alias of !exit instead of displaying: {code} Error: Error while compiling statement: FAILED: ParseException line 1:0 cannot recognize input near 'exit' 'EOF' 'EOF' (state=42000,code=4) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-6683) Beeline does not accept comments at end of line
[ https://issues.apache.org/jira/browse/HIVE-6683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14145092#comment-14145092 ] Jeremy Beard commented on HIVE-6683: [~spena] That example is for a comment at the start of the line. Could you please confirm the example as listed in the JIRA description? Beeline does not accept comments at end of line --- Key: HIVE-6683 URL: https://issues.apache.org/jira/browse/HIVE-6683 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Beeline fails to read queries where lines have comments at the end. This works in the embedded Hive CLI. Example: SELECT 1 -- this is a comment about this value FROM table; Error: Error while processing statement: FAILED: ParseException line 1:36 mismatched input 'EOF' expecting FROM near '1' in from clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (HIVE-6806) Native Avro support in Hive
[ https://issues.apache.org/jira/browse/HIVE-6806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14060998#comment-14060998 ] Jeremy Beard commented on HIVE-6806: Would that mean with this patch we still need to specify the SerDe when creating an Avro table? Native Avro support in Hive --- Key: HIVE-6806 URL: https://issues.apache.org/jira/browse/HIVE-6806 Project: Hive Issue Type: New Feature Components: Serializers/Deserializers Affects Versions: 0.12.0 Reporter: Jeremy Beard Assignee: Ashish Kumar Singh Priority: Minor Labels: Avro Attachments: HIVE-6806.patch Avro is well established and widely used within Hive, however creating Avro-backed tables requires the messy listing of the SerDe, InputFormat and OutputFormat classes. Similarly to HIVE-5783 for Parquet, Hive would be easier to use if it had native Avro support. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14006157#comment-14006157 ] Jeremy Beard commented on HIVE-6684: [~xuefuz] Those failures do not involve the beeline component, so I would say not. Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch, HIVE-6684.2.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Attachment: HIVE-6684.2.patch Good point Xuefu. Added patch that only trims once. Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch, HIVE-6684.2.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Attachment: HIVE-6684.2.patch Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch, HIVE-6684.2.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Attachment: (was: HIVE-6684.2.patch) Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch, HIVE-6684.2.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Attachment: HIVE-6684.1.patch Added patch with unit test - please review. Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Fix Version/s: 0.14.0 Status: Patch Available (was: Open) Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Fix For: 0.14.0 Attachments: HIVE-6684.1.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Updated] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeremy Beard updated HIVE-6684: --- Fix Version/s: (was: 0.14.0) Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Attachments: HIVE-6684.1.patch Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Created] (HIVE-6806) Native Avro support in Hive
Jeremy Beard created HIVE-6806: -- Summary: Native Avro support in Hive Key: HIVE-6806 URL: https://issues.apache.org/jira/browse/HIVE-6806 Project: Hive Issue Type: New Feature Components: Serializers/Deserializers Affects Versions: 0.12.0 Reporter: Jeremy Beard Priority: Minor Avro is well established and widely used within Hive, however creating Avro-backed tables requires the messy listing of the SerDe, InputFormat and OutputFormat classes. Similarly to HIVE-5783 for Parquet, Hive would be easier to use if it had native Avro support. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Created] (HIVE-6683) Beeline does not accept comments at end of line
Jeremy Beard created HIVE-6683: -- Summary: Beeline does not accept comments at end of line Key: HIVE-6683 URL: https://issues.apache.org/jira/browse/HIVE-6683 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Beeline fails to read queries where lines have comments at the end. This works in the embedded Hive CLI. Example: SELECT 1 -- this is a comment about this value FROM table; Error: Error while processing statement: FAILED: ParseException line 1:36 mismatched input 'EOF' expecting FROM near '1' in from clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Created] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
Jeremy Beard created HIVE-6684: -- Summary: Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Commented] (HIVE-6684) Beeline does not accept comments that are preceded by spaces
[ https://issues.apache.org/jira/browse/HIVE-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13938156#comment-13938156 ] Jeremy Beard commented on HIVE-6684: The description doesn't render properly on my browser - the 2nd, 3rd and 5th lines of the example start with three spaces. Beeline does not accept comments that are preceded by spaces Key: HIVE-6684 URL: https://issues.apache.org/jira/browse/HIVE-6684 Project: Hive Issue Type: Bug Components: CLI Affects Versions: 0.10.0 Reporter: Jeremy Beard Beeline throws an error if single-line comments are indented with spaces. This works in the embedded Hive CLI. For example: SELECT -- this is the field we want field FROM table; Error: Error while processing statement: FAILED: ParseException line 1:71 cannot recognize input near 'EOF' 'EOF' 'EOF' in select clause (state=42000,code=4) -- This message was sent by Atlassian JIRA (v6.2#6252)