michTalebzadeh commented on issue #2387: URL: https://github.com/apache/iceberg/issues/2387#issuecomment-2843641473
I tried this code and it works somehow ``` set hive.support.concurrency=true; set hive.txn.strict.locking.mode=false; DROP VIEW IF EXISTS alayer.joint_accounts_view; set hive.support.concurrency=false; CREATE VIEW alayer.joint_accounts_view AS SELECT * FROM ilayer.joint_accounts; DESCRIBE EXTENDED alayer.joint_accounts_view; !exit blh -f create_view_alayer.joint_accounts_view.hql WARNING: HADOOP_PREFIX has been replaced by HADOOP_HOME. Using value of HADOOP_PREFIX. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/data6/hduser/apache-hive-4.0.1-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/hduser/hadoop-3.4.1/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] WARNING: HADOOP_PREFIX has been replaced by HADOOP_HOME. Using value of HADOOP_PREFIX. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/data6/hduser/apache-hive-4.0.1-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/hduser/hadoop-3.4.1/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Connecting to jdbc:hive2://rhes75:10099/default Connected to: Apache Hive (version 4.0.1) Driver: Hive JDBC (version 4.0.1) Transaction isolation: TRANSACTION_REPEATABLE_READ Running init script /home/hduser/dba/bin/add_jars.hql 25/05/01 00:04:43 [main]: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 0: jdbc:hive2://rhes75:10099/default> --ADD JAR hdfs://rhes75:9000/jars/hive-serde-0.11.0.jar; 0: jdbc:hive2://rhes75:10099/default> ADD JAR hdfs://rhes75:9000/jars/hive-serde-4.0.1.jar; No rows affected (0.044 seconds) 0: jdbc:hive2://rhes75:10099/default> ADD JAR hdfs://rhes75:9000/jars/hive-bigquery-storage-handler-1.0-shaded.jar; No rows affected (0.042 seconds) 0: jdbc:hive2://rhes75:10099/default> set hive.support.concurrency=false; No rows affected (0.002 seconds) 0: jdbc:hive2://rhes75:10099/default> 0: jdbc:hive2://rhes75:10099/default> 0: jdbc:hive2://rhes75:10099/default> set hive.support.concurrency=true; No rows affected (0.002 seconds) 0: jdbc:hive2://rhes75:10099/default> set hive.txn.strict.locking.mode=false; No rows affected (0.003 seconds) 0: jdbc:hive2://rhes75:10099/default> DROP VIEW IF EXISTS alayer.joint_accounts_view; No rows affected (0.212 seconds) 0: jdbc:hive2://rhes75:10099/default> set hive.support.concurrency=false; No rows affected (0.002 seconds) 0: jdbc:hive2://rhes75:10099/default> CREATE VIEW alayer.joint_accounts_view AS SELECT * FROM ilayer.joint_accounts; No Stats for elayer@metro_11296807, Columns: transactiondate, accountnumber, accountname, op_time, description, moneyin, op_type, transactiontype, moneyout, sortcode No Stats for elayer@nw_10124772, Columns: transactiondate, accountnumber, accountname, op_time, description, op_type, value, transactiontype, sortcode No rows affected (0.153 seconds) 0: jdbc:hive2://rhes75:10099/default> DESCRIBE EXTENDED alayer.joint_accounts_view; etc ``` -- 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: issues-unsubscr...@iceberg.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org For additional commands, e-mail: issues-h...@iceberg.apache.org
