[jira] [Commented] (HAWQ-1222) can't set optimizer to be on after enabling gporca

["Xiang Sheng (JIRA)" <ji...@apache.org>]

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

Xiang Sheng commented on HAWQ-1222:
-----------------------------------

[~huxiao64]  Could you add more details about how to reproduce this problem ?  os  and version, some build log, which code base , what did you try, etc.

I cannot reproduce this problem when I build hawq with orca. You can check my steps listed as below: 

./configure --enable-orca
make
make install
source greenplum_path.sh
postgres=# show optimizer;
 optimizer
-----------
 on
(1 row)

postgres=#

check your build with several tips: 
1. ./configure --help to see different options for build. do you configure as "./configure --enable-orca" ? 
2. if build hawq without enable orca, the optimizer is off , we cannot set optimizer to on. HAWQ will ERROR out with "ERROR:  Pivotal Query Optimizer not supported by this build" when set optimizer to on.  But if we build hawq and enable orca,   default optimizer mode is on, no need to set optimizer to on.  
3. Do you "make distclean" before you build hawq ? Because there maybe some problems if you didn't clean these objs since you change the configs of building hawq. If you didn't do it, you can try again. 
4. After build hawq with enable orca, do you remember to restart your hawq  ? 

Thanks

> can't set optimizer to be on after enabling gporca
> --------------------------------------------------
>
>                 Key: HAWQ-1222
>                 URL: https://issues.apache.org/jira/browse/HAWQ-1222
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Build
>            Reporter: Xiao Hu
>            Assignee: Ed Espino
>             Fix For: 2.0.1.0-incubating
>
>
> after building HAWQ with orca, I can not set optimizer to be on either in the HAWQ system or in the single query session.
> postgres=# set optimizer = on;
> ERROR:  Pivotal Query Optimizer not supported by this build



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)