search

polypheny / Polypheny-DB

A self-adaptive Polystore that provides cost- and workload aware access to heterogeneous data.
https://polypheny.org
Apache License 2.0
122 stars 82 forks source link

Bad lines in query plan view #281

Open vogti opened 3 years ago

vogti commented 3 years ago

There is a minor rendering bug in the query plan view of the Polypheny-UI.

Bildschirmfoto 2021-03-10 um 15 23 39

This issue can be reproduced by executing the following query in the SQL query console and opening the physical plan view:

select * from emps e1, emps e2, depts d1, depts d2 
where e1.deptno = d1.deptno and e2.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d2.deptno

The query uses the demo tables available in every fresh Polypheny-DB instance.

Please be aware that the physical query plan is only shown on the first execution of a query due to the implementation caching. Either reset the implementation cache in the monitoring view or disable implementation caching entirely (Config -> Query Processing -> runtime/implementationCaching ).

ayu023ban commented 3 years ago

Hi! I would like to apply to Polypheny in the GSoC 21. To start with my contribution to the community I want to work on this issue. Could you please asign me it?

vogti commented 3 years ago

Hi @ayu023ban, welcome to Polypheny! I have assigned the issue to you. Please follow this on how to set up Polypheny-DB in your favorite IDE and this guide on how to manually build Polypheny-UI. Feel free to ask here or open a thread in the discussions forum if you have any questions or experience any issues with setup.

vogti commented 3 years ago

Hi @ayu023ban, is everything working fine? If you have any issues or need help getting started, please do not hesitate to either ask here or open a thread in the discussion forum.

erdengk commented 2 years ago

Hi, @vogti Can you tell me where the Java code or HTML of the generated graph is located? DB has many modules. I often don't know where to start to solve these problems.🤣

vogti commented 2 years ago

Hi @erdengk The frontend-code of the UI lives in its own repository. The Polypheny-UI is based on Angular and follows the common structure.

C-mmon commented 2 years ago
image

No longer able to replicate this issue

vogti commented 2 years ago

Hi @C-mmon The example query indeed does not show this problem anymore. However, if you expand the query, it is still present: select * from emps e1, emps e2, emps e3, depts d1, depts d2, depts d3 where e1.deptno = d1.deptno and e2.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d2.deptno and e1.deptno = d3.deptno

Screenshot 2022-04-09 at 21 07 23

Do you want to take care of this issue?

gvjkumar2004 commented 1 year ago

I would like to work on this issue and if possible can anyone explain this issue as this is my first contribution!

AlessiaTang commented 8 months ago

Hi @vogti My name is Alessia. I am currently a master's student at the University of Washington majoring in Information Management and want to apply to the Polypheny in the GSoC 24. To start with my contribution to the community, I'd like to work on this Bad lines in query plan view #281 issue. Could you please kindly assign it to me? Thank you : )

EslamAsHhraf commented 7 months ago

@vogti @hennlo HI, If there aren't anyone work on this issue, I would like to work on it and I think that I can solve it after go deep on code