Comments (1)
@nickhristov : thanks for reporting the issue.
One comment, with CQL's CREATE TABLE syntax:
PRIMARY KEY (col_a, col_b)
is effectively same as:
PRIMARY KEY ((col_a), col_b)
and both would result in col_a being hash/partition column, and col_b being a clustering column,
If you wanted both columns be part of the hash/partition columns in the PRIMARY KEY, then you'll need an extra set of parens as below:
PRIMARY KEY ((col_a, col_b))
Nevertheless, in either case, looks like we do have an issue with the IN clause not being optimized to do an index lookup - and it might be that we are doing a scan here instead. We will get a fix out to you soon.
@m-iancu : Assigning this to you.
from yugabyte-db.
Related Issues (20)
- [YSQL] Remove query plan costs from yb_planner_joins regression tests
- [DocDB] ysql_dump: Add SPLIT INTO 1 TABLETS
- [YSQL] Remove query plan costs from yb_select_no_pushdown regression tests
- [YSQL] load_relcache_init_file should clear yb_table_properties
- [xCluster] Unify xCluster Stream creation
- [DocDB] Failed to write a batch with 0 operations into RocksDB: Corruption (yb/dockv/doc_kv_util.cc:135): Error when decoding hashed components of a document key HOT 1
- Restarting Connection Manager doesn't initialise shared memory for stats
- Investigate RULES object support on source PG support in live migration
- [DocDB] Node failed + core dump on load running against node HOT 3
- [CDCSDK] [PG Parity] One of the run without tablet splitting and nemesis, saw more rows in PG sink than YB source
- [yugabyted] xCluster Integration with yugabyted.
- [YSQL] Incomplete ErrorData sent from the background workers
- [YSQL] ANALYZE <multiple-tables> commits kPlain transaction while DDL transaction is active
- [DocDB] Add LB Dashboard for LB metrics in Vesuvius for CE investigations.
- [YSQL] yb_get_range_split_clause failed to decode GinNull in GIN Index partition bounds
- Bug: Schema modification not getting applied to case sensitive or case sensitive reserved words table
- [YSQL] Partitions still create tables on pg-side failures
- [YSQL] pg_cron: Use stateful service to assign cron leader
- [DocDB] LTO executables do not get re-linked when dependencies change
- [YSQL] PgIndexBackfillTest.InsertsWhileCreatingIndexDisableWait frequently fails on TSAN
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 yugabyte-db.