Search:

Type: Posts; User: pmartel

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    1,321

    Note that hex encoding is not the same thing as...

    Note that hex encoding is not the same thing as base64 encoding. maybe bin2hex is the function you want?
  2. Yes, LocalCluster accepts 3 parameters that match...

    Yes, LocalCluster accepts 3 parameters that match settings in the normal deployment.xml on a production system:
    the number of hosts (server processes, usually on separate VMs or machines)
    the...
  3. VoltDB uses our own fork of modules from the HSQL...

    VoltDB uses our own fork of modules from the HSQL project within our product.
    Most of VoltDB's SQL DDL and SQL statement parsing uses HSQL's parser.
    Various tools and utilites in the VoltDB package...
  4. The LocalCluster class is part of our test...

    The LocalCluster class is part of our test framework that has the ability to test different aspects or modes of the product.
    NATIVE_EE_JNI means that we are testing the default "ee" (execution...
  5. I have investigated this issue and narrowed it...

    I have investigated this issue and narrowed it down to a parser bug.
    Small adjustments to the query like adding levels of parentheses around nested expressions with parameters (that is '?') or even...
  6. Replies
    5
    Views
    1,079

    I am having trouble reproducing this. Here's the...

    I am having trouble reproducing this.
    Here's the DDL-centered try I made:

    CREATE TABLE table1 (
    DEVICE VARCHAR(23) NOT NULL,
    USERNAME VARCHAR(23) NOT NULL,
    );

    PARTITION TABLE table1 ON...
  7. Replies
    2
    Views
    523

    This appears to be a known issue in our...

    This appears to be a known issue in our interactive ad hoc sql front ends -- are you entering this query into sqlcmd?

    It may be possible to get the front end to accept the union syntax by...
  8. Replies
    13
    Views
    2,467

    In my opinion, while this might work, it could be...

    In my opinion, while this might work, it could be made safer -- to more closely mimic the code path of the mainstream use cases.
    Since there are multiple VoltProcedure instances -- 1 outer and 2...
  9. Replies
    5
    Views
    832

    "The column on which most searches are going to...

    "The column on which most searches are going to be performed" is intended to include queries that filter multiple columns.
    So, for your two example queries, either col1 or col2 is a candidate for...
  10. Replies
    5
    Views
    1,133

    Assuming that column is of type INTEGER, int[] is...

    Assuming that column is of type INTEGER, int[] is the way to go. What happened when you tried that?
  11. Replies
    6
    Views
    2,742

    To confirm Xin's suspicion, it does appear that...

    To confirm Xin's suspicion, it does appear that the "truncate" command is not supported through our jdbc interface.
    "DELETE FROM history" WILL do the same thing. Also, this command became much more...
  12. Kamal, I apologize for the confusion. The...

    Kamal,
    I apologize for the confusion. The ability to support more than two tables in an outer join has only been released so far in our open source code offering.
    This capability will be...
  13. Kamal, This problem is solved by using a more...

    Kamal,
    This problem is solved by using a more recent version of VoltDB.
    Paul
  14. Replies
    1
    Views
    495

    The inability to reference groupby columns in the...

    The inability to reference groupby columns in the HAVING clause is a known limitation in the current product.
    You should be able to work around this by using MAX(groupby_column) in place of...
  15. Yes, VoltDB supports left and right outer joins...

    Yes, VoltDB supports left and right outer joins using the standard LEFT JOIN and RIGHT JOIN syntax (as shown). The number of joined tables is limited to 5 except in the context of a java stored...
  16. VoltDB supports the sql standard query syntax for...

    VoltDB supports the sql standard query syntax for outer joins, so your query would have to be something like:

    SELECT a.PARENTTYPE,a.PARENTVALUE, b.PARENTTYPE,b.PARENTVALUE,...
  17. Replies
    2
    Views
    1,303

    Nick, In release 3.7, future use of the...

    Nick,
    In release 3.7, future use of the elastic feature must be enabled in the original configuration at cluster start up using the elastic attribute in the deployment.xml file:

    <deployment>
    ...
  18. Replies
    3
    Views
    3,628

    The problem might just be with the embedded "."s...

    The problem might just be with the embedded "."s in the name. Try:

    CREATE PROCEDURE FetchUsers AS
    SELECT * FROM USERS WHERE user_id=?;

    PARTITION PROCEDURE FetchUsers
    ON TABLE Users COLUMN...
  19. Replies
    1
    Views
    1,031

    VoltDB supports a limited view definition syntax...

    VoltDB supports a limited view definition syntax as described here:

    http://voltdb.com/docs/UsingVoltDB/ddlref_createview.php

    Your view definition contains the following elements that are...
  20. Replies
    4
    Views
    1,684

    It looks like the problem may be in how you are...

    It looks like the problem may be in how you are calling the java client APIs to process the result. Can you send a code sample of how you are calling the procedure and then counting the rows in your...
  21. Replies
    3
    Views
    1,351

    SKK, I'm happy to hear that you were able to...

    SKK,

    I'm happy to hear that you were able to work out your sorting issue.

    Some members of our team were recently discussing percentile queries in the context of the related issue of optimizing...
  22. Replies
    3
    Views
    1,351

    VoltDB does not currently support percentile or...

    VoltDB does not currently support percentile or windowing functions in general, but it does have support for ORDER BY ... DESC.

    If you wish to post some sample queries that aren't working for you,...
  23. Left and right outer join support are newly...

    Left and right outer join support are newly available in a limited form in VoltDB release 3.3.
    The current limitation is that outer joins are limited to queries joining two tables.
    General...
  24. Sticky: Diego, All of the "PARTITION PROCEDURE...

    Diego,

    All of the "PARTITION PROCEDURE ProcedureSelectEmp ..." statements after the first one are redundant.
    The TABLE and COLUMN specifiers merely identify the type of the procedure's...
  25. Replies
    2
    Views
    1,189

    The VoltDB engineering team has also discussed...

    The VoltDB engineering team has also discussed providing automatic support for "capped collections". With this feature, the memory size of a table is managed by the automatic eviction of older/colder...
Results 1 to 25 of 45
Page 1 of 2 1 2