You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@impala.apache.org by Alex Behm <al...@cloudera.com> on 2016/04/18 18:11:35 UTC

Re: Can I insert overwrite two tables to one complex type table with struct?

On Mon, Apr 18, 2016 at 9:11 AM, Alex Behm <al...@cloudera.com> wrote:

> Moving to user@impala.incubator.apache.org.
>
> Impala currently cannot generate and insert complex types, but you can do
> it with Hive.
>
> You need to join the fact and dim table and then collect_list() with an
> appropriate group by.
>
> Alex
>
> On Mon, Apr 18, 2016 at 2:50 AM, 吴朱华 <ik...@gmail.com> wrote:
>
>> Hi Guys:
>>
>> I have one question regarding the impala support for complex types.  For
>> example, there are three tables, one is fact table, one is dim table, one
>> is complex type table with struct, of course the schema for complex table
>> is combination of the fact table and the dim table, So can I insert
>> overwrite fact table and dim table to one complex type table with struct?^_^
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Impala User" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to impala-user+unsubscribe@cloudera.org.
>>
>
>