hyrise / rl_index_selection

Paper repository for "SWIRL: Selection of Workload-aware Indexes using Reinforcement Learning" (EDBT 2022)
Other
28 stars 17 forks source link

somthing about he running environment #2

Open Wolfboyccc opened 4 months ago

Wolfboyccc commented 4 months ago

Does SWIRL have a version that runs on Windows? I always encounter errors when running it on Windows.

Bouncner commented 4 months ago

Hi Wolfboyccc,

what exactly is the issue you are facing?

Wolfboyccc commented 3 months ago

I want to know if my modifications regarding make_command and the cmd part are correct, as it seems like the operation of creating tables didn't execute, and I'm getting an error about an empty table. image image

Wolfboyccc commented 3 months ago

Through my debugging, I found that the value of self.columns becomes empty after running a filtering operation at line 25 of a schema.py. This is causing the issue of getting empty rows. for filter_name in filters.keys(): filter_class = getattr(importlib.import_module("swirl.schema"), filter_name) filter_instance = filter_class(filters[filter_name], self.database_name) self.columns = filter_instance.apply_filter(self.columns)

Bouncner commented 3 months ago

Does is run without those modifications? I doubt I will abe able to debug your code from screenshots.

Wolfboyccc commented 3 months ago

The issue regarding 'make_command' and 'cmd' has been resolved. It may have been due to the absence of the 'make' command in Windows. I downloaded Mingw64 and changed the command to 'make'. The current problem is that 'Self.columns' gets filtered out as empty when running the following filter code at line 25 of a schema.py, ultimately leading to issues image

Bouncner commented 3 months ago

Can you please check if there is data loaded in Postgres? The query should return something.

Wolfboyccc commented 3 months ago

I have checked the Postgres database and, after the creation operation, generated a database called indexselection_tpch___10. There are eight tables in this database, but each table has very few columns, so they should all have been filtered out. I would like to inquire about which part of the table creation process went wrong. NZX~}H2K9%JW$MS4L Z9ME5 %( PZEAY00(L4ZUU_7A6NPM

Bouncner commented 3 months ago

Do the tables have any rows?