Comments (5)
Hi thanks for your interest in FOCUS. I'm looking into this issue as several users have recently reported it. It looks like sqlite has a limit of the number of variables that can be used within an 'IN' statement (999).
I'm working on a bugfix that will require getting results in batches and joining them together after-the-fact rather than all at once.
from focus.
Hello @geneticsmcgill , I just released a new version (0.5) of FOCUS that should address this issue. You can install either by pulling the latest from the repo and installing, or using pip.
Please let me know if you have any other questions or issues.
This was fixed by commit: ff06df0
from focus.
If users are still running into this issue I would recommend updating the sqlite software with conda or another package manager. The software limit implemented in pyfocus is based on a newer sqlite version and there is no clean way to programmatically determine what the limit is. Given that, the simplest solution is to update sqlite.
from focus.
I also ran into this issue and am not sure what sqlite3 version is expected. Here is what I saw when checking the sqlite3 version in python.
`Python 3.6.5 (default, Jun 19 2018, 16:28:05)
[GCC 6.2.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
import sqlite3
sqlite3.version
'2.6.0'
sqlite3.sqlite_version
'3.7.17'`
what version is expected?
from focus.
Here is what I have on my end:
In [3]: sqlite3.sqlite_version
Out[3]: '3.26.0'
In [4]: sqlite3.version
Out[4]: '2.6.0'
from focus.
Related Issues (20)
- Integer column has NA values in column 3 HOT 4
- unsupported operand type(s) for +: 'float' and 'str' HOT 3
- Focus import error - "500 Server Error: Internal Server Error for url: http://mygene.info/v3/query/" HOT 2
- ERROR] MetaData.__init__() got multiple values for argument 'schema' HOT 1
- error in creating the weight database HOT 3
- symbol issue when creating weight database using Predixcan databases HOT 5
- name 'zscores' is not defined errror with when running finemap with --intercept HOT 2
- The TWAS z-score obtained by S-PrediXcan and FOCUS software is different
- [WARNING] Unable to match ENSG00000228327.3 to Ensembl ID. Using ID for symbol HOT 2
- The --prior-prob parameter set for DNA methylation based fine-mapping analysis
- p-values in the output plot is on negative natural log scale? HOT 2
- Some example files/databases unavailable
- data for re-plotting the expression correlation as in the plot output
- "block" issue on FOCUS HOT 3
- focus finemap error HOT 6
- [error] dataframe.pivot() takes 1 positional argument but 4 were given HOT 7
- Modifying the focus.db
- Error when perform finemap for splicing-based association study
- ERROR] pivot() takes 1 positional argument but 4 were given
- munge error 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 focus.