rl_index_selection icon indicating copy to clipboard operation
rl_index_selection copied to clipboard

somthing about he running environment

Open Wolfboyccc opened this issue 11 months ago • 8 comments

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

Wolfboyccc avatar Mar 21 '24 08:03 Wolfboyccc

Hi Wolfboyccc,

what exactly is the issue you are facing?

Bouncner avatar Mar 24 '24 04:03 Bouncner

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 avatar Mar 27 '24 07:03 Wolfboyccc

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)

Wolfboyccc avatar Mar 27 '24 07:03 Wolfboyccc

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

Bouncner avatar Mar 31 '24 06:03 Bouncner

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

Wolfboyccc avatar Apr 01 '24 02:04 Wolfboyccc

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

Bouncner avatar Apr 05 '24 03:04 Bouncner

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

Wolfboyccc avatar Apr 07 '24 01:04 Wolfboyccc

Do the tables have any rows?

Bouncner avatar Apr 18 '24 08:04 Bouncner