[jira] [Created] (HIVE-26687) INSERT query with array type failing with SemanticException
Manthan B Y created HIVE-26687: -- Summary: INSERT query with array type failing with SemanticException Key: HIVE-26687 URL: https://issues.apache.org/jira/browse/HIVE-26687 Project: Hive Issue Type: Bug Components: Hive Reporter: Manthan B Y *Steps to reproduce:* {code:java} DROP TABLE IF EXISTS default.tbl_oGSJ; CREATE TABLE default.tbl_oGSJ (c1 array); INSERT INTO default.tbl_oGSJ(c1) VALUES (array(55,54)); {code} *Error:* {code:java} Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Cannot insert into target table because column number/types are different 'TOK_TMP_FILE': Cannot convert column 0 from array to array. (state=42000,code=4) {code} The same is the case for bigint, tinyint as well -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-26688) VectoredIO based ORC config
Harshit Gupta created HIVE-26688: Summary: VectoredIO based ORC config Key: HIVE-26688 URL: https://issues.apache.org/jira/browse/HIVE-26688 Project: Hive Issue Type: Improvement Reporter: Harshit Gupta -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-26689) INSERT query with array type failing with SemanticException (Unable to do implicit cast)
Manthan B Y created HIVE-26689: -- Summary: INSERT query with array type failing with SemanticException (Unable to do implicit cast) Key: HIVE-26689 URL: https://issues.apache.org/jira/browse/HIVE-26689 Project: Hive Issue Type: Bug Components: Hive Reporter: Manthan B Y *Steps to reproduce:* {code:java} DROP TABLE IF EXISTS default.tbl_oGSJ; CREATE TABLE default.tbl_oGSJ (c1 array); INSERT INTO default.tbl_oGSJ(c1) VALUES(array('2006-09-25','1980-07-19','1992-02-11'));{code} *Error:* {code:java} Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Cannot insert into target table because column number/types are different 'TOK_TMP_FILE': Cannot convert column 0 from array to array. (state=42000,code=4){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)
[GitHub] [hive-site] zabetak commented on a diff in pull request #2: HIVE-26565: Revamp Apache Hive website
zabetak commented on code in PR #2: URL: https://github.com/apache/hive-site/pull/2#discussion_r1011633264 ## themes/hive/layouts/partials/banner.html: ## @@ -0,0 +1,39 @@ + + + + + + + +Apache Hive v4 Review Comment: Please remove v4 from the main header. This information can get obsolete and changing the main header may interfere with search engines. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[GitHub] [hive-site] zabetak commented on a diff in pull request #2: HIVE-26565: Revamp Apache Hive website
zabetak commented on code in PR #2: URL: https://github.com/apache/hive-site/pull/2#discussion_r1011637383 ## themes/hive/layouts/partials/explain.html: ## @@ -0,0 +1,43 @@ + + + +jdbc:hive2://localhost:10001/> explain select * from test; + ++-+ + Explain ++-+ +STAGE DEPENDENCIES: + Stage-0 is a root stage +STAGE PLANS: + Stage: Stage-0 +Fetch Operator + limit: -1 + Processor Tree: +TableScan + alias: test + Statistics: Num rows: 16 Data size: 2880 Basic stats: COMPLETE Column stats: NONE + Select Operator +expressions: id (type: int), name (type: string), intid (type: int) +outputColumnNames: _col0, _col1, _col2 +Statistics: Num rows: 16 Data size: 2880 Basic stats: COMPLETE Column stats: NONE +ListSink ++-+ + Review Comment: Since we are talking about CBO here it would be better to change the example to use `EXPLAIN CBO` and maybe use a less trivial query with 2-3 joins, aggregation, and filter. Also using a well-known datataset (such as TPC-H or TPC-DS) would make this more realistic. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
[jira] [Created] (HIVE-26690) Redirect hive-site notifications to the appropriate mailing lists
Stamatis Zampetakis created HIVE-26690: -- Summary: Redirect hive-site notifications to the appropriate mailing lists Key: HIVE-26690 URL: https://issues.apache.org/jira/browse/HIVE-26690 Project: Hive Issue Type: Task Components: Website Reporter: Stamatis Zampetakis Assignee: Stamatis Zampetakis Currently various notifications from [hive-site|https://github.com/apache/hive-site] repository, such as opening/reviewing/commenting pull requests, are send to the [dev mailing list|https://lists.apache.org/list.html?dev@hive.apache.org] (e.g., [https://lists.apache.org/thread/xthvd9m148xkhshco772llckfc1qk0sf]). The respective notifications from the main [hive repository|https://github.com/apache/hive] are send to the [gitbox mailing list|https://lists.apache.org/list.html?git...@hive.apache.org]. The goal of this ticket is to redirect the notifications for hive-site repository from dev to gitbox/commit mailing lists by modifying the [.asf.yaml file|https://cwiki.apache.org/confluence/display/INFRA/Git+-+.asf.yaml+features#Git.asf.yamlfeatures-Notificationsettingsforrepositories]. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-26691) Generate thrift files by default at compilation time
Alessandro Solimando created HIVE-26691: --- Summary: Generate thrift files by default at compilation time Key: HIVE-26691 URL: https://issues.apache.org/jira/browse/HIVE-26691 Project: Hive Issue Type: Task Components: Thrift API Affects Versions: 4.0.0-alpha-2 Reporter: Alessandro Solimando Currently Hive does not generate thrift files within the main compilation task ({_}mvn clean install -DskipTests{_}), but it uses a separate profile ({_}mvn clean install -Pthriftif -DskipTests -Dthrift.home=$thrift_path{_}), and thrift-generated files are generally committed in VCS. Other Apache projects like Parquet ([https://github.com/apache/parquet-mr/blob/master/parquet-thrift/pom.xml)] use a different approach, building all thrift files by default in the main compilation task. In general, generated files should not be part of our VCS, only the "source" file should be (.thrift files here). Including generated files in VCS is not only problematic because they are verbose and clog PR diffs, but they also generate a lot of conflicts (even when the changes over the thrift file can be merged automatically). The ticket proposes to move the thrift files generation at compile time, remove the thrift-generated files from VCS, and add them to the "ignore" list. -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-26692) Check for the expected thrift version before compiling
Alessandro Solimando created HIVE-26692: --- Summary: Check for the expected thrift version before compiling Key: HIVE-26692 URL: https://issues.apache.org/jira/browse/HIVE-26692 Project: Hive Issue Type: Task Components: Thrift API Affects Versions: 4.0.0-alpha-2 Reporter: Alessandro Solimando At the moment we don't check for the thrift version before launching thrift, the error messages are often cryptic upon mismatches. An explicit check with a clear error message would be nice, like what parquet does: [https://github.com/apache/parquet-mr/blob/master/parquet-thrift/pom.xml#L247-L268] -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Created] (HIVE-26693) HS2 can not read/write hive_catalog iceberg table created by other engines
zhangbutao created HIVE-26693: - Summary: HS2 can not read/write hive_catalog iceberg table created by other engines Key: HIVE-26693 URL: https://issues.apache.org/jira/browse/HIVE-26693 Project: Hive Issue Type: Improvement Components: HiveServer2, StorageHandler Affects Versions: 4.0.0-alpha-2 Reporter: zhangbutao -- This message was sent by Atlassian Jira (v8.20.10#820010)