[jira] [Commented] (ASTERIXDB-3195) Need a debug option to enumerate all plans without pruning during join enumeration.

2023-09-08 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/ASTERIXDB-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17763291#comment-17763291
 ] 

ASF subversion and git services commented on ASTERIXDB-3195:


Commit 4e5aa99155eed03ba2b91a16a0b3ce8debc8fe82 in asterixdb's branch 
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=4e5aa99155 ]

[ASTERIXDB-3195][COMP] Add query properties to enumerate all plans.

- user model changes: yes
- storage format changes: no
- interface changes: no

Details:
Add query properties to enumerate all plans without pruning during
join enumeration. This will help debug issues when good plans may
have been pruned off due to incorrect costing or other reasons.

New properties are:
- "cbofullenumlevel": Num of levels to do full join and plan enumeration.
- "cbocpenum": true/false for cartesian product plan generation.

Change-Id: I7c3e23cc2d24ff16cb026d4fbb317445db1b2574
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17756
Integration-Tests: Jenkins 
Tested-by: Jenkins 
Reviewed-by: Vijay Sarathy 
Reviewed-by: Ali Alsuliman 


> Need a debug option to enumerate all plans without pruning during join 
> enumeration.
> ---
>
> Key: ASTERIXDB-3195
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3195
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: COMP - Compiler
>Affects Versions: 0.9.8.1
>Reporter: Vijay Sarathy
>Assignee: Vijay Sarathy
>Priority: Minor
>  Labels: triaged
> Fix For: 0.9.9
>
>
> It would be very useful for testing and debugging purposes to have an 
> internal flag to turn off pruning during join enumeration. This will enable 
> us to debug issues when good plans may have been pruned off due to incorrect 
> costing or other reasons.
> We need to ensure that we don't degrade the current planning process.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (ASTERIXDB-3195) Need a debug option to enumerate all plans without pruning during join enumeration.

2023-06-16 Thread ASF subversion and git services (Jira)


[ 
https://issues.apache.org/jira/browse/ASTERIXDB-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733671#comment-17733671
 ] 

ASF subversion and git services commented on ASTERIXDB-3195:


Commit 3d58eac00372768594cde5c7f04ab59d68cad1f0 in asterixdb's branch 
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=3d58eac003 ]

[ASTERIXDB-3195][COMP] Add query properties to enumerate all plans

- user model changes: yes
- storage format changes: no
- interface changes: no

Details:
Add query properties to enumerate all plans without pruning during
join enumeration. This will help debug issues when good plans may
have been pruned off due to incorrect costing or other reasons.

New properties are:
- "cbofullenumlevel": Num of levels to do full join and plan enumeration.
- "cbocpenum": true/false for cartesian product plan generation.

Change-Id: Ie99c7310ebfca075f3211f32195fb2ad5df7c470
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17550
Reviewed-by: Vijay Sarathy 
Reviewed-by: Ali Alsuliman 
Integration-Tests: Jenkins 
Tested-by: Jenkins 


> Need a debug option to enumerate all plans without pruning during join 
> enumeration.
> ---
>
> Key: ASTERIXDB-3195
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3195
> Project: Apache AsterixDB
>  Issue Type: Bug
>  Components: COMP - Compiler
>Affects Versions: 0.9.8.1
>Reporter: Vijay Sarathy
>Assignee: Vijay Sarathy
>Priority: Minor
>  Labels: triaged
> Fix For: 0.9.9
>
>
> It would be very useful for testing and debugging purposes to have an 
> internal flag to turn off pruning during join enumeration. This will enable 
> us to debug issues when good plans may have been pruned off due to incorrect 
> costing or other reasons.
> We need to ensure that we don't degrade the current planning process.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)