Colossus
commented
9 years ago EDIT: PLEASE IGNORE THIS COMMENT SEE THE COMMENT BELOW
Hey Sen,
pelase disregard the create_input_schema.sh and create_schema.sh scripts --- these were created for a few less technically informed members a long while ago. Please use psql -f util/schema.sql and psql-f util/input_schema.sql to create the schema and input schema (WARNING: THESE SCRIPTS AUTOMATICALLY DROP THE TABLES BEFORE THEY ARE CREATED AGAIN. IF YOU JUST WANT ONE PARTICULAR TABLE, COPY PASTE IT MANUALLY.)
I'm going to remove the shell scripts.
Johannes
On 8/22/15 1:39 PM, SenWu wrote:
I am a litter confused about the schema of sentences table.
In tutorial, Step 3 said "Create the input data schema by running: ./util/create_input_schema.sh (NOTE that this will drop any input data already loaded into e.g. sentences or sentences_input tables)" and schema schema is CREATE TABLE sentences ( doc_id text, section_id text, sent_id int, ref_doc_id text, words text[], lemmas text[], poses text[], ners text[], dep_paths text[], dep_parents int[] ) DISTRIBUTED BY (doc_id, section_id);
But in Step 5, the schema for sentences table is: CREATE TABLE ${TABLE} ( doc_id TEXT, section_id TEXT, ref_doc_id TEXT, sent_id TEXT, words TEXT[], lemmas TEXT[], poses TEXT[], ners TEXT[], dep_paths TEXT[], dep_parents INT[] )
They are not the same, can you clarify it?
In the application.conf, we will create sentences_input from sentences. So, we don't need define its schema in Step 3, right?
— Reply to this email directly or view it on GitHub https://github.com/HazyResearch/dd-genomics/issues/138.
ajratner
I am a litter confused about the schema of sentences table.
In tutorial, Step 3 said "Create the input data schema by running: ./util/create_input_schema.sh (NOTE that this will drop any input data already loaded into e.g. sentences or sentences_input tables)" and schema schema is CREATE TABLE sentences ( doc_id text, section_id text, sent_id int, ref_doc_id text, words text[], lemmas text[], poses text[], ners text[], dep_paths text[], dep_parents int[] ) DISTRIBUTED BY (doc_id, section_id);
But in Step 5, the schema for sentences table is: CREATE TABLE ${TABLE} ( doc_id TEXT, section_id TEXT, ref_doc_id TEXT, sent_id TEXT, words TEXT[], lemmas TEXT[], poses TEXT[], ners TEXT[], dep_paths TEXT[], dep_parents INT[] )
They are not the same, can you clarify it?
In the application.conf, we will create sentences_input from sentences. So, we don't need define its schema in Step 3, right?