Comments (2)
It looks like hex encoding of binary data. Most likely the query you see in the log is generated by the driver itself.
What is the problem with this query? Is there any error during data transfer?
from dbeaver.
@serge-rider There is no error in data transfer.
But ClickHouse cannot parse the received data correctly and thus throws errors.
I guess DBeaver gets the encoding from ClickHouse, but ClickHouse returned an invalid encoding.
if I know the SQL DBeaver used to get the encoding, then I can let ClickHouse return the correct encoding.
Here is the call stack from DBeaver
<!--StartFragment--></meta><style><!--br {mso-data-placement:same-cell;}--> td {white-space:nowrap;border:1px solid #dee0e3;font-size:10pt;font-style:normal;font-weight:normal;vertical-align:middle;word-break:normal;word-wrap:normal;}</style><byte-sheet-html-origin data-id="1715066935417" data-version="4" data-is-embed="false" data-grid-line-hidden="false" data-importRangeRawData-spreadSource="https://bytedance.sg.larkoffice.com/sheets/GbvOsXyxshEh2qtLwzElUmQBgee" data-importRangeRawData-range="Errors!E63:E63">
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [62] [HY000]: Code: 62, e.displayText() = DB::Exception: Syntaxerror: failed at position 30 ('<EF><BF><BD>') (line 1, col 30): <E6><97><A5><E6><9C><9F>,<E5><9F><8E><E5><B8><82>,<E5><8D><95><E6><8D><AE><E7><BC><96><E5><8F><B7>,<E9><97><A8><E5><BA><97><E5><90><8D><E7><A7><B0>,<E5><95><86><E5><93><81><E<E7><B1><BB><E5><88><AB>,<E5><95><86><E5><93><81><E5><90><8D><E7><A7><B0>,<E7><9C><81><E4><BB><BD>,<E6><88><90><E6><9C><AC><E9><A2><9D>,<E6><AF><88><A9><E9><A2><9D>,<E6><95><B0><E9><87><8F>,<E9><94><80><E5><94><AE><E9><A2><9D>) VALUES ('2020-01-01',x'7d7102',x'534d44424a31383. Unrecognized token: '<EF><BF><BD>' SQLSTATE: 42000 (version 21.8.7.1) at
org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatementBatch(JDBCStatementImpl.java:155) at
org.jkiss.dbeaver.model.impl.data.ExecuteBatchImpl.flushBatch(ExecuteBatchImpl.java:290) at
org.jkiss.dbeaver.model.impl.data.ExecuteBatchImpl.processBatch(ExecuteBatchImpl.java:212) at
org.jkiss.dbeaver.model.impl.data.ExecuteBatchImpl.execute(ExecuteBatchImpl.java:81) at
org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferConsumer.lambda$0(DatabaseTransferConsumer.java:456) at
org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:191) at
org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferConsumer.insertBatch(DatabaseTransferConsumer.java:454) at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferConsumer.fetchRow(DatabaseTransferConsumer.java:401) at org.jkiss.dbeaver.tools.transfer.stream.importer.DataImporterCSV.runImport(DataImporterCSV.java:278) at
org.jkiss.dbeaver.tools.transfer.stream.StreamTransferProducer.transferData(StreamTransferProducer.java:161) at
org.jkiss.dbeaver.tools.transfer.stream.StreamTransferProducer.transferData(StreamTransferProducer.java:1) at
org.jkiss.dbeaver.tools.transfer.DataTransferJob.transferData(DataTransferJob.java:119) at
org.jkiss.dbeaver.tools.transfer.DataTransferJob.run(DataTransferJob.java:91) at
org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:114) at
org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
--
</byte-sheet-html-origin><!--EndFragment-->
from dbeaver.
Related Issues (20)
- [CUBRID] Provide more information on Query Plan TableView HOT 1
- If I use Oracle 23c driver F4 won't work (it works with other drivers) HOT 10
- Dbeaver began to make a slow opening on Citrix machines HOT 4
- Running query in a block without highlighting no longer works HOT 12
- Transaction Blocks not working after most recent update HOT 2
- Window for "Select Data Source" disappears seconds after switching tabs, right as you're selecting a data source
- SQL Error [42501]: ERROR: permission denied for table
- DBeaver incorrectly gives syntax error highlighting HOT 8
- Can't install update 24.0.4 on Mac OS Catalina 10.15.7
- Enhancement of Key Derivation in DefaultValueEncryptor.java
- Unable to build properly HOT 2
- WHY i cant import, i was doing that before successfully. java heap space? HOT 2
- M3 MAC DBeaver unable to connect to any database due to "Network Unavailable SSL Handshake Exception error"
- Add a refresh button on the "choose catalog/schema" modal HOT 1
- When export CSV files column separate error with column value contains CSV comma separator. HOT 2
- Incorrect syntax near ';'. error on valid DECLARE statement in SQL Server 2019 HOT 4
- No column was specified for column 22 of 'dbvrcnt' HOT 3
- How to set-up Redshift Connection on dBeaver CE when using Configuration file on a Mac HOT 3
- License incompatibility - proprietary licence in Community Edition HOT 1
- For MariaDB, add Require SSL checkbox in user Properties | DBA Privileges page HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbeaver.