[ https://issues.apache.org/jira/browse/IMPALA-8953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16933609#comment-16933609 ]
Tim Armstrong commented on IMPALA-8953: --------------------------------------- [~vihangk1] fyi > Tables and Databases sharing same name can cause query failures if table is > not readable by Impala > -------------------------------------------------------------------------------------------------- > > Key: IMPALA-8953 > URL: https://issues.apache.org/jira/browse/IMPALA-8953 > Project: IMPALA > Issue Type: Improvement > Components: Catalog > Reporter: Karan Datta > Priority: Minor > > Please see below scenario: > 1) CREATE DATABASE a; > 2) Create tables "a.b" and "default.a". However, create "default.a" in a > format which Impala cannot read. For example: Open CSV Serde from Hive. > 3) Connect to Impala and execute below statements - > a) INVALIDATE METADATA; > b) use default; > c) select * from a.b; > Above query will lead to following exception: > CAUSED BY: TableLoadingException: Unrecognized table type for table: default.a > If the database of query "select * from a.b;" is changed to any other > database then, the query executes successfully. For example: > use test1 or use test; > select * from a.b; > Also, if the table "default.a" is created with a format that Impala can > read/load, query "select * from a.b" executes successfully. > Above scenario occurs as Impala can refer to the collection column b in table > a in database default, or it can refer to table b in database a. As Impala > cannot disambiguate between the two cases unless it knows that there is a > collection column b be in default.a, it loads metadata of table "default.a" > while executing query on table "a.b". If the table "default.a" exists and is > not readable by Impala, any query executed on tables available in database > "a" from default database will fail. For a better UX, we should > improve/change this behavior. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org