aliyun / alibabacloud-odps-maxframe-client

Apache License 2.0
3 stars 1 forks source link

Disabling optimizer.projection_same_index_merge stops df[df['a']='x'] from generating a WHERE clause #46

Open hh23485 opened 4 days ago

hh23485 commented 4 days ago
config.options.dag.settings = {
    # "optimizer.groupbyagg_same_index_merge": False,
    "optimizer.projection_same_index_merge": False
}

session = new_session(o)
print(session.session_id)

table = md.read_odps_table("meta.m_instance", partitions="ds=20240625", index_col="id")
table.head(10).execute().fetch()

table_filtered =table[table['owner_kp'] == '1734437963789551']
table_filtered.execute().fetch()

Here is a logview screenshot, the second execution will loss the where condition

image