[ https://issues.apache.org/jira/browse/HIVE-9465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14296335#comment-14296335 ]
Xuefu Zhang commented on HIVE-9465: ----------------------------------- Yeah. In that case, this JIRA should be an improvement rather than a bug. There is no bug as this is by design. Also, you need to think about backward compatibility when proposing your solution. > Table alias is ineffective when do loading dynamic partition > ------------------------------------------------------------ > > Key: HIVE-9465 > URL: https://issues.apache.org/jira/browse/HIVE-9465 > Project: Hive > Issue Type: Bug > Components: CLI, Physical Optimizer > Affects Versions: 0.13.1 > Reporter: Liao, Xiaoge > > sql: > drop table schema_test_xgliao; > create table schema_test_xgliao( a string) PARTITIONED by (p String); > set hive.exec.dynamic.partition=true; > set hive.exec.dynamic.partition.mode=nonstrict; > insert OVERWRITE table schema_test_xgliao > PARTITION (p) > select a as p, b from schema_test1_xgliao ; > It will use "b" for the value of partion. -- This message was sent by Atlassian JIRA (v6.3.4#6332)