You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Gabor Kaszab (Jira)" <ji...@apache.org> on 2020/03/04 12:35:00 UTC

[jira] [Commented] (IMPALA-2777) Support complex-typed expressions in the select list of views

    [ https://issues.apache.org/jira/browse/IMPALA-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17051166#comment-17051166 ] 

Gabor Kaszab commented on IMPALA-2777:
--------------------------------------

I did a quick check and for me it seems that this lack of functionality is broader than querying from views. Apparently, Impala doesn't allow any complex type in the select list regardless if it's a view or table.

Let me re-write the subject of this Jira to reflect this. Additionally, this work seems more complicated than it seems at first sight so let me remove the ramp-up label.

> Support complex-typed expressions in the select list of views
> -------------------------------------------------------------
>
>                 Key: IMPALA-2777
>                 URL: https://issues.apache.org/jira/browse/IMPALA-2777
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Frontend
>    Affects Versions: Impala 2.3.0
>            Reporter: Andrew Lam
>            Priority: Minor
>              Labels: planner, ramp-up, usability
>
> We use `CREATE VIEW` in HIVE to strip out columns containing sensitive information from tables, and grant access to these views to a subset of users.
> Impala queries involving complex types work on the original table but not on the view.
> Is this expected?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org