You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "sky-cc (via GitHub)" <gi...@apache.org> on 2023/11/28 07:51:54 UTC
[I] [Bug] [jdbc-catalog]When writing to an external table, it is not written in the field order of insert, but in the field order of the table [doris]
sky-cc opened a new issue, #27695:
URL: https://github.com/apache/doris/issues/27695
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
2.0.2
### What's Wrong?
When writing to an external table, it is not written in the field order of insert, but in the field order of the table
### What You Expected?
fix it
### How to Reproduce?
create table in doris1(version:2.0.2)
CREATE TABLE `test` (
`gameid` varchar(50) NOT NULL DEFAULT "",
`aid` int(11) NOT NULL DEFAULT "0",
`bid` int(11) NOT NULL DEFAULT "0",
`cid` int(11) NOT NULL DEFAULT "0",
`did` int(11) NOT NULL DEFAULT "0",
`pname` varchar(255) NOT NULL DEFAULT "其他"
) ENGINE=OLAP
UNIQUE KEY(`gameid`, `aid`, `bid`, `cid`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`gameid`) BUCKETS 3
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);
executing the sql in doris2(version:2.0.2)
insert into doris1.test.test(gameid,did,cid,bid,aid,pname) values('g1',4,3,2,1,'p1');

### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] [jdbc-catalog]When writing to an external table, it is not written in the field order of insert, but in the field order of the table [doris]
Posted by "liugddx (via GitHub)" <gi...@apache.org>.
liugddx commented on issue #27695:
URL: https://github.com/apache/doris/issues/27695#issuecomment-1830105392
Try it with the latest version
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] [jdbc-catalog]When writing to an external table, it is not written in the field order of insert, but in the field order of the table [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #27695: [Bug] [jdbc-catalog]When writing to an external table, it is not written in the field order of insert, but in the field order of the table
URL: https://github.com/apache/doris/issues/27695
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] [jdbc-catalog]When writing to an external table, it is not written in the field order of insert, but in the field order of the table [doris]
Posted by "Yulei-Yang (via GitHub)" <gi...@apache.org>.
Yulei-Yang commented on issue #27695:
URL: https://github.com/apache/doris/issues/27695#issuecomment-1829794857
I will look into it
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org