Comments (5)
Are you sure the example works? OCR example cannot pass on my side.
The issue is that there are TWO variables in ONE table.
Assigining ID will only give ONE id to each ROW, but there are two variables in this row.
How are we dealing with this? I guess one solution is to restrict that every table can only contain one variable, update the example and docs...
02:35:40 [] ERROR SQL execution failed (Reason: ERROR: duplicate key value violates unique constraint "label2_pkey"
Detail: Key (id)=(620) already exists.):
UPDATE label2 SET id = nextval('id_sequence')
02:35:40 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] ERROR org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "label2_pkey"
Detail: Key (id)=(620) already exists.
02:35:40 [PostgresInferenceDataStoreComponent$PostgresInferenceDataStore(akka://deepdive)] INFO [Error] Please check the SQL cmd!
02:35:40 [inferenceManager] ERROR ERROR: duplicate key value violates unique constraint "label2_pkey"
Detail: Key (id)=(620) already exists.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "label2_pkey"
Detail: Key (id)=(620) already exists.
from deepdive.
Two variables are not in the same table. We have label1, label2. The problem is id is declared as primary key. This can be solved by declaring id as bigint.
CREATE TABLE label1(
id BIGSERIAL PRIMARY KEY,
wid INT, val BOOLEAN);
CREATE TABLE label2(
id BIGSERIAL PRIMARY KEY,
wid INT, val BOOLEAN);
from deepdive.
Awesome! Would you fix it?
from deepdive.
Yes, I fixed it locally. I'll push it later on.
from deepdive.
Done in b0d123a
from deepdive.
Related Issues (20)
- How to set host and port of Mindbender gui ?
- how to import deepdive in python HOT 1
- ddlib not work in python3
- 'deepdive do sentences' is running for unlimited time without producing results HOT 4
- Get an error "~/util/load-computer-driver.sh: line24: DEEPDIVE_COMPUTER_TYRE: unbound variable",when run "deepdive do articles"
- #Unsupported Operating System: MINGW64_NT-6.1 HOT 1
- error: curl: (23) Failed writing body (0 != 16360) and error: curl: (7) couldn't connect to host, when installing deepdive
- curl error
- Can't start CoreNLP in sandbox (In windows and mac). HOT 3
- ## Failed installation for _deepdive_runtime_deps
- fATAL: password authentication failed for user "root"
- psql: FATAL: role "infotop" does not exist solution HOT 1
- Deepdive run Error :When I run ‘deepdive do probabilities’
- uninstaller
- error while installing Minikube
- while generate mention ERROR: missing data for column "mention_text"
- The map mention operation does not save the result in the database,when the sentence length exceeds 100 words.
- DeepDive dependencises
- deepdive command not working
- Hi @mcavdar, 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 deepdive.