Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

how to do normal query in Javascript? Convert it to Arrow Table? #558

Open
archywillhe opened this issue Oct 12, 2023 · 4 comments
Open

how to do normal query in Javascript? Convert it to Arrow Table? #558

archywillhe opened this issue Oct 12, 2023 · 4 comments

Comments

@archywillhe
Copy link

archywillhe commented Oct 12, 2023 •
edited
Loading

Hi. I'm testing out the JS API for lancedb. I noticed there isn't any way to query by Id, index, etc. All queries are done via distance cal (and even with .where targetting one entry of specific ID, it ends up taking 700ms to return a result).

Just wondering if I want to quickly get a specific entry by a field selector (eg a sql WHERE clause), what is the best way to do it? Load LanceDB into Arrow Table?

thanks!
@archywillhe
Copy link
Author

related to this: #261

@archywillhe
Copy link
Author

aw looks like there is a solution in python #470
but i've gone through the docs & test-cases in js and haven't found anything similiar

@samlhuillier
Copy link

Also interested in this. Any update?

@changhiskhan
Copy link
Contributor

The code was merged #693
The documentation is here: #736

alexkohler pushed a commit to alexkohler/lancedb that referenced this issue Apr 20, 2024
@eddyxu
Use Datafusion physical ExecutionPlan node as I/O exec node (lancedb#558
1cff06e 
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@changhiskhan @archywillhe @samlhuillier