Comments (4)
imay
commented on May 11, 2024
这个问题是因为把' 作为了一个字节。比如你查like '%j%'就会有结果出来了
from doris.
crcc
commented on May 11, 2024
不太明白，把哪个'作为了一个字节？那下面select * from table1 where username = 'jim'这个怎么查？
from doris.
imay
commented on May 11, 2024
select * from table1 where username = "'jim'"，是说你在源文件里面写的是'jim'，那么导入的就是'jim'，如果你想导入jim，那么源文件应该写的是jim
from doris.
crcc
commented on May 11, 2024
啊，明白了，没反应过来'是字符串的一部分
from doris.
Related Issues (20)
- [Bug] LEFT JON数据一会多一会少
- [Bug] backend节点实际使用的磁盘空间超出数据真实大小过多 HOT 3
- [Bug] java udf load fail log when be is started HOT 1
- [Bug] select from EXTERNAL TABLE from ELASTICSEARCH nested field has array value error HOT 2
- [Bug] 使用paimon catalog 查询带有is null报错
- [Bug] 官网倒排索引的sql缺少’
- [Bug] No matching function with signature: cosine_distance HOT 5
- [Bug] Multiple subqueries executing Lateral VIEW explore_ Split causes data to return null
- [Bug] Select cast (1 as json); throws NullPointerException, msg: java.lang.NullPointerException: null HOT 1
- [Bug] When connecting to an external Hive table, encountering a non-existent function will prompt an error indicating lack of permission.
- [Bug] select full table without group by and order by，query use large memory，be memory exceed limit HOT 1
- [Bug] Doris' DATETIMEV2 & DECIMALV3 Data Type not support for BI Metabase MySQL Data Sources HOT 3
- [Feature] stream_load default timezone change to UTC+0
- [Bug] old planner and Nereids Planner can not return same result HOT 1
- json_extract查询问题 HOT 3
- [Bug] When querying the Hive external table, an Invalid data error occurred. HOT 2
- doris对select中的字段进行了常量折叠 对于grouping中和grouping sets中的字段没有进行常量折叠 [Bug]
- [Feature] Looking to increase kafa support Routine Load kafka_topic_list support
- DATETIME类型插入数据时区转化问题 HOT 1
- [Bug] Illegal column UInt64 of first argument of function toDateTime on INSERT prepared statement with datetime column
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 doris.