Failed to execute system_status script example via sql

[WenyXu]

What type of bug is this?

Unexpected error

What subsystems are affected?

Datanode

What happened?

Follow the doc, upload the system_status.py.

Execute sql select system_status();

However, it works via http (curl -XPOST \ "http://localhost:4000/v1/run-script?name=system_status&db=public")

What operating system did you use?

Ubuntu 23.04

Relevant log output and stack trace

2023-10-07T06:16:05.292265Z  WARN servers::mysql::server: Internal error occurred during query exec, server actively close the channel to let client try next time err=0: Other error, at src/servers/src/mysql/writer.rs:151:68
1: , at src/common/recordbatch/src/adapter.rs:203:55
2: External(0: Failed to execute Python UDF: 0: Coprocessor's Internal error: Can't find field name idc in all columns in RecordBatch { schema: Schema { column_schemas: [ColumnSchema { name: "host", data_type: Null(NullType), is_nullable: true, is_time_index: false, default_constraint: None, metadata: {} }], name_to_index: {"host": 0}, arrow_schema: Schema { fields: [Field { name: "host", data_type: Null, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }], metadata: {"greptime:version": "0"} }, timestamp_index: None, version: 0 }, columns: [ConstantVector([Null; 1])], df_record_batch: RecordBatch { schema: Schema { fields: [Field { name: "host", data_type: Null, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }], metadata: {"greptime:version": "0"} }, columns: [NullArray(1)], row_count: 1 } }, at src/script/src/python/ffi_types/copr.rs:221:50, at src/script/src/python/engine.rs:164:14)

How can we reproduce the bug?

Follows the doc, updates the system_status.py.

Executes sql select system_status();Follows the doc, updates the system_status.py.

Executes sql select system_status();Follows the doc, updates the system_status.py.

Executes sql select system_status();

[killme2008]

Can't find field name idc in all columns in RecordBatch

You have to ensure the sysetm_metrics table was created.

[WenyXu]

Can't find field name idc in all columns in RecordBatch

You have to ensure the sysetm_metrics table was created.

I do have this table, it works via http

[killme2008]

Got it, you mean execute it by SQL? It can't work, the result is expected.

If you want to call the python UDF in sql ,it must follow some rules.

[WenyXu]

Got it, you mean execute it by SQL? It can't work, the result is expected.

If you want to call the python UDF in sql ,it must follow some rules.

Ok, let's close it.

[killme2008]

Please create an issue in https://github.com/GreptimeTeam/docs

I will update the user guide to describe the rules.