You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "fsilent (via GitHub)" <gi...@apache.org> on 2023/05/25 07:52:07 UTC
[GitHub] [doris-spark-connector] fsilent opened a new issue, #101: [Bug] ConnectedFailedException: Connect to Doris BE{host='xxx', port=9060}failed
fsilent opened a new issue, #101:
URL: https://github.com/apache/doris-spark-connector/issues/101
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
doris: master
spark: 3.3.1
scala: 2.12
### What's Wrong?
doris spark connector select data failed.
### What You Expected?
select data success
### How to Reproduce?
doris side:
CREATE TABLE spark_connector_test_decimal (c1 int NOT NULL, c2 VARCHAR(25) NOT NULL, c3 VARCHAR(152),
c4 boolean,
c5 tinyint,
c6 smallint,
c7 bigint,
c8 float,
c9 double,
c10 datev2,
c11 datetime,
c12 char,
c13 largeint,
c14 varchar,
c15 decimalv3(15, 5)
)
DUPLICATE KEY(`c1`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c1`) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
insert into spark_connector_test_decimal values(10000,'aaa','abc',true, 100, 3000, 100000, 1234.567, 12345.678, '2022-12-01','2022-12-01 12:00:00', 'a', 200000, 'g', 1000.12345);
insert into spark_connector_test_decimal values(10001,'aaa','abc',false, 100, 3000, 100000, 1234.567, 12345.678, '2022-12-01','2022-12-01 12:00:00', 'a', 200000, 'g', 1000.12345);
insert into spark_connector_test_decimal values(10002,'aaa','abc',True, 100, 3000, 100000, 1234.567, 12345.678, '2022-12-01','2022-12-01 12:00:00', 'a', 200000, 'g', 1000.12345);
insert into spark_connector_test_decimal values(10003,'aaa','abc',False, 100, 3000, 100000, 1234.567, 12345.678, '2022-12-01','2022-12-01 12:00:00', 'a', 200000, 'g', 1000.12345);
select * from spark_connector_test_decimal;
spark side:
CREATE TEMPORARY VIEW spark_doris_decimal
USING doris
OPTIONS(
"table.identifier"="sparkconnector.spark_connector_test_decimal",
"fenodes"="fe_host:8030",
"user"="root",
"password"=""
);
select * from spark_doris_decimal;
### 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
[GitHub] [doris-spark-connector] fsilent closed issue #101: [Bug] ConnectedFailedException: Connect to Doris BE{host='xxx', port=9060}failed
Posted by "fsilent (via GitHub)" <gi...@apache.org>.
fsilent closed issue #101: [Bug] ConnectedFailedException: Connect to Doris BE{host='xxx', port=9060}failed
URL: https://github.com/apache/doris-spark-connector/issues/101
--
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
[GitHub] [doris-spark-connector] fsilent commented on issue #101: [Bug] ConnectedFailedException: Connect to Doris BE{host='xxx', port=9060}failed
Posted by "fsilent (via GitHub)" <gi...@apache.org>.
fsilent commented on issue #101:
URL: https://github.com/apache/doris-spark-connector/issues/101#issuecomment-1562572944
After continue test, i found because of datev2 and decimalv3 not support. The debug log info is :
The status of open scanner result from Doris BE{host='', port=} is 'INVALID_ARGUMENT', error message is: [()[INVALID_ARGUMENT]Unknown primitive type(29)
--
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
[GitHub] [doris-spark-connector] fsilent commented on issue #101: [Bug] ConnectedFailedException: Connect to Doris BE{host='xxx', port=9060}failed
Posted by "fsilent (via GitHub)" <gi...@apache.org>.
fsilent commented on issue #101:
URL: https://github.com/apache/doris-spark-connector/issues/101#issuecomment-1563765357
found this doc
--
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