Column name 'company_type_code' not in table 'assets_maintenance'

[henghuiz-zz]

In train_spider.json, there is one example with a question What is the description of the type of the company who concluded its contracts most recently? and a query SELECT T1.company_name FROM Third_Party_Companies AS T1 JOIN Maintenance_Contracts AS T2 ON T1.company_id = T2.maintenance_contract_company_id JOIN Ref_Company_Types AS T3 ON T1.company_type_code = T3.company_type_code ORDER BY T2.contract_end_date DESC LIMIT 1. But the column name 'company_type_code' not in table 'assets_maintenance'. Please check if there is something wrong in this example. I think the column name should be company_type.

[MottoX]

This problem causes an exception when using parse_raw_json.py to generate new json file. From my side, the corresponding database assets_maintenance lacks a table named Ref_Company_Types.

[taoyds]

Hi,

We might accidentally delete company_type_code. I will double check this example and update them in the later version. Thanks!

Best,
Tao

[tin-chata]

Hi there,

Did you fix this issue? It seems that the current dataset lacks of ref_company_types table and and company_type_code column (in the Third_Party_Companies table) too.

Thanks

[chenyangh]

It seems that this issue is still not fixed.

[YonghyunRyu]

This issue still exists. There is a KeyError: ref_company_types.

[WaNePr]

This issue still exists. and causes the output vocabulary when running run.py includes vocab = [..., company_type_code, ref_company_types,...].

[BoCiFOM]

The issue still exists. Any fixes for this?