You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Jie Zhang <ji...@gmail.com> on 2015/04/01 02:33:59 UTC

empty plan shows when explaining CTAS query

When explaining a CTAS query, no execution plan shows somehow.

0: jdbc:hive2://localhost:10000/default> explain create table if not exists
test1 as select c1, count(distinct c2) as cnt from test group by c1 order
by c1;

+----------------------+--+

|       Explain        |

+----------------------+--+

| STAGE DEPENDENCIES:  |

|                      |

| STAGE PLANS:         |

+----------------------+--+

3 rows selected (0.215 seconds)

I have an application to check execution plan for the hive query, and
recently upgraded hive from 0.13.1 to 0.14.0. It works fine before upgrade.
Does anyone hit the same issue? Is it caused by a regression bug or I miss
some property setting? Any help is appreciated. Thanks!

Jessica