nferrario commented on issue #22647:
URL: https://github.com/apache/doris/issues/22647#issuecomment-1697505464
Hi everyone, I can't seem to get partial_columns working (attaching
screenshots and snipped in this thread):
```
Execution failed: Error Failed to execute sql: java.sql.SQLException:
(conn=18) errCode = 2, detailMessage = partial_columns is invalid property
```
Is there anything I'm missing? I'm using the latest 2.0.0 build from the
main website.
```sql
CREATE TABLE IF NOT EXISTS sms_toolbox
(
`message_id` CHAR(36) NOT NULL,
`customer_id` INT NOT NULL,
`provider_id` INT NOT NULL,
`bind_id` INT NOT NULL,
`node_id` INT NOT NULL,
`routing_zone_id` INT NOT NULL,
`country_code` INT NOT NULL,
`event` INT NOT NULL,
`status` INT NOT NULL,
`source` STRING NOT NULL,
`operator_code` INT NOT NULL,
`account_id` INT NOT NULL,
)
UNIQUE KEY (`message_id`)
DISTRIBUTED BY HASH(`message_id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"enable_unique_key_merge_on_write" = "true"
);
CREATE ROUTINE LOAD sms_toolbox_routine_load ON sms_toolbox
PROPERTIES
(
"max_batch_interval" = "20",
"max_batch_rows" = "300000",
"max_batch_size" = "209715200",
"format" = "json",
"partial_columns" = "true"
)
FROM KAFKA
(
"kafka_broker_list" = "10.1.1.175:9092,10.1.1.174:9092,10.1.1.173:9092",
"kafka_topic" = "sms-toolbox",
"property.group.id" = "doris",
"property.client.id" = "doris",
"property.kafka_default_offsets" = "OFFSET_BEGINNING"
);
```
Version: `doris-2.0.0-rc04-96bb9a7`
And from the Home web page:
```
Git : git://VM-10-6-centos@96bb9a7d0881cabf114c3618585fa18549d7b2ea
Version : doris-2.0.0-rc04
BuildInfo : VM-10-6-centos
BuildTime : Sun, 06 Aug 2023 16:25:12 UTC
```
Perhaps the build that's uploaded isn't the final 2.0.0? I just found this
stacktrace with (doris-fe.jar:1.2-SNAPSHOT):
```
Caused by: java.sql.SQLException: (conn=21) errCode = 2, detailMessage =
partial_columns is invalid property
at
org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:287)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:358)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:133)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:815)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:765)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:673)
~[mariadb-java-client-3.0.4.jar:?]
at
org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:616)
~[mariadb-java-client-3.0.4.jar:?]
at org.mariadb.jdbc.Statement.executeInternal(Statement.java:906)
~[mariadb-java-client-3.0.4.jar:?]
at org.mariadb.jdbc.Statement.execute(Statement.java:1031)
~[mariadb-java-client-3.0.4.jar:?]
at org.mariadb.jdbc.Statement.execute(Statement.java:441)
~[mariadb-java-client-3.0.4.jar:?]
at
org.apache.doris.httpv2.util.StatementSubmitter$Worker.call(StatementSubmitter.java:120)
~[doris-fe.jar:1.2-SNAPSHOT]
at
org.apache.doris.httpv2.util.StatementSubmitter$Worker.call(StatementSubmitter.java:83)
~[doris-fe.jar:1.2-SNAPSHOT]
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
