uwescience / uwescience/query-workload-analysis

How do I actually get started using this tool?

Open
#3 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

question
Dominant language
TeX
Stars
13
Forks
2
PR merge metrics
No merged PRs in 30d

Description

I followed the instructions in the README.md, they were easy. However, it is not obvious what to do once the command will execute on the command line...

Here's my attempt to load the existing SDSS query log into the database: qwla sdss consume workloadanalysis/ProcessedQueries_sdss.csv -v -d sqlite:///sdss.db

Output: Imported 1 of 1 (workloadanalysis/ProcessedQueries_sdss.csv)

However, it does not seem to have done anything to the DB:

% sqlite3 sdss.db 
SQLite version 3.7.13 2012-07-17 17:46:21
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
CREATE TABLE everything (
    id INTEGER NOT NULL, 
    PRIMARY KEY (id)
);
sqlite> select * from everything;
sqlite>
query-workload-analysis % ls -l *.db
-rw-r--r-- 1 dhalperi staff 2048 Jul 30 17:06 sdss.db

So, it seems like it did not actually put any data in the database. What am I doing wrong?

FYI: @domoritz @shrjain @7andrew7

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with README.md and the reported qwla ... consume ... -d sqlite:///sdss.db command, then inspect the generated sdss.db with sqlite3. Clarify the expected post-import workflow and database contents, and update the usage documentation so a newcomer can verify a successful import.

Written by the indexing model from the issue text.

Assessment

Tech stack
sqlite
Domain
cli, database, documentation
Issue type
Documentation
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.