verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing
http://verdictdb.org
Apache License 2.0
248 stars 66 forks source link

Basic documentation #173

Closed pyongjoo closed 6 years ago

pyongjoo commented 6 years ago

I have reorganized the basic document structure and added some comments. Please write the content.

FYI, for local documentation,

cd docs
mkdocs serve
Beastjoe commented 6 years ago

Never mind. I have found it is uploaded.

Beastjoe commented 6 years ago

Hi Yongjoo, for connection part, does this method works?

String connectionString = "jdbc:verdictdb:mysql://localhost";
VerdictContext verdict = new VerdictContext(connectionString);

I am using

String connectionString = "jdbc:mysql://localhost";
VerdictContext verdict = VerdictContext.fromConnectionString(connectionString);
pyongjoo commented 6 years ago

I don't think I have told you that to work based on the code pushed to the yongjoo-docs branch. It's using H2 as an example.

Btw, the first code does not work. But the same connetion string including "verdictdb" works for DriverManager.getConnection(connetionString).

Beastjoe commented 6 years ago

May I ask how user can create scramble table? VerdictContext has method scramble(), but it is a private field of VerdictConnection.

pyongjoo commented 6 years ago

It is using a sql query like "create scramble newschema.newtable from oldschema.oldtable".

On Wed, Jul 25, 2018 at 4:53 PM Beastjoe notifications@github.com wrote:

May I ask how user can create scramble table? VerdictContext has method scramble(), but it is a private field of VerdictConnection.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/173#issuecomment-407891742, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQYCiUuBWwVCpEs4km4cD8W1IsmxqJ0ks5uKNq1gaJpZM4VgUeV .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com

Beastjoe commented 6 years ago

Hi Yongjoo,

I find in ExecutionContext, when it is a scrambling type, this logic seems only create a scramble coordinator, but do nothing to the database.

else if (queryType.equals(QueryType.scrambling)) {
      ScramblingCoordinator coordinator = new ScramblingCoordinator(context.getCopiedConnection());
      return null;
}

It is in streamsql() method

pyongjoo commented 6 years ago

A logic will be added.

On Wed, Jul 25, 2018 at 5:17 PM Beastjoe notifications@github.com wrote:

Hi Yongjoo,

I find in ExecutionContext, when it is a scrambling type, this logic seems only create a scramble coordinator, but do nothing to the database.

else if (queryType.equals(QueryType.scrambling)) { ScramblingCoordinator coordinator = new ScramblingCoordinator(context.getCopiedConnection()); return null; }

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mozafari/verdictdb/issues/173#issuecomment-407898903, or mute the thread https://github.com/notifications/unsubscribe-auth/ABQYCkEyxcCD3A6rJX68FBtkxXCzrlvbks5uKOBygaJpZM4VgUeV .

-- Yongjoo Park, Ph.D. Research Fellow Computer Science and Engineering University of Michigan 2260 Hayward St. Ann Arbor, MI 48109-2121 Office: 4957 Beyster Phone: (734) 707-9206 Website: yongjoopark.com

pyongjoo commented 6 years ago

I close this issue that has been assigned to @Beastjoe .

I have to add more documentation.