Where to find the latest release and some questions on the usage.

[puneet.a...@gmail.com]

Hi Brian

First of all thank you for writing Virgil.

I am trying to use Virgil Rest API to talk to cassandra in my POC

I tried finding the latest release of Virgil that has all the dependencies in it at 

https://github.com/hmsonline/virgil/releases

However, it does not have ./lib folder. The only place were I could find a complete release without additional dependencies iscode.google.com . But that release is fairly old 0.11 release.

Neverthe less, I was able to get 0.11 release working with my cassandra install through datastax.  I have some questions which are not clearly addressed in the usage section on the virgil wiki page.

1. How do I pass an integer as partition key to get access to a record.

Here 'id' is my partition key.

 curl -X GET http://localhost:8080/virgil/data/art_raw/mines/204/

I get the following error...

"Expected 4 or 0 byte int (3)

2. What if I have compound primary key say

id1 ( type varchar) 

id2 ( type int)

Cluster key1  ( type int)

cluster key2 (type varchar) ..

How should I pass the paramters in the URL for such cases.

3. How do I get reponse in more readable format.

I am getting the character codes for the values. Most of them are either varchar or INTs.

$ curl -X GET http://localhost:8080/virgil/data/art_raw/company_share2/FMG/

{"\u0000\u0000\u0000":"","\u0000\u0007id_port\u0000":"\u0000\u0000<\u0004","\u0000\u0006status\u0000":"Operating","\u0000\tindicated\u0000":"@�\u0014{","\u0000\u0007deleted\u0000":"\u0000\u0000\u0000\u0000","\u0000\u0007percent\u0000":"B�\u0000\u0000","\u0000\tid_vertex\u0000":"\u0000\u0000Mp","\u0000\u0002id\u0000":"\u0000\u0000\u0001�","\u0000\bdisabled\u0000":"\u0000\u0000\u0000\u0000","\u0000\nid_account\u0000":"\u0000\u0000\u0000\u0000","\u0000\u0012production_planned\u0000":"B�"}

4. What if i want to create a column family with one column that is an integer. How to create it via this rest API. It seems by default all columns are assumed to be text.

Regards

Puneet

[Brian O'Neill]

Puneet,

Thanks.  I’m presently in the process of creating a new REST server that uses the CQL driver (instead of the thrift interfaces).  Thus, I haven’t made much progress on Virgil in some time.

You are more than welcome to use it however, or extend it, to meet your need.

You can get the latest up and running (per my last email).   That may have what you need, if it doesn’t — I know support for additional datatypes was always on the “todo” list.

Let me know if there is anything else I can do to help you out.

-brian

---

Brian O'Neill 

Chief Technology Officer

Health Market Science, a LexisNexis Company

215.588.6024 Mobile • @boneill42 

This information transmitted in this email message is for the intended recipient only and may contain confidential and/or privileged material. If you received this email in error and are not the intended recipient, or the person responsible to deliver it to the intended recipient, please contact the sender at the email above and delete this email and any attachments and destroy any copies thereof. Any review, retransmission, dissemination, copying or other use of, or taking any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited.

 

--
You received this message because you are subscribed to the Google Groups "virgil-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to virgil-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Puneet Aggarwal]

Thank you so much Brian. 
I was able to build the latest release as per your instructions. I understand virgil does not support all data types at the moment.I intend to use the it , at the moment, only for POC purpose.  Two questions I have is,

1. I want to query a column family with partition key of INT data type. Is the INT data type supported for get request. If yes, how do i build get request for the same?

 curl -X GET http://localhost:8080/virgil/data/art_raw/mines/204/

I get the following error...

"Expected 4 or 0 byte int (3)

2. I know memnon (Rest api via CQL) has not been released yet, But, If I build its current , would it support get requests on column family with partition key as INT.

Regards

Puneet

2. Does the current code of Memon