Search:

Type: Posts; User: bballard

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Hi interntest, I just updated the...

    Hi interntest,

    I just updated the app-bank-offers to provide two example deployment.xml files for the Hortonworks sandbox, and Cloudera quickstart. You were correct to add %g, that was missing...
  2. Replies
    3
    Views
    210

    The overhead of parsing and planning AdHoc...

    The overhead of parsing and planning AdHoc queries is significant if you are trying to process thousands of Ad Hoc queries per second. Ad Hoc queries are automatically partitioned by the planner if...
  3. Replies
    4
    Views
    100

    VoltDB is an in-memory database. The working...

    VoltDB is an in-memory database. The working data set needs to be stored in tables in memory. It can scale to many nodes in a cluster so it is not limited to the memory of a single server.
  4. Replies
    4
    Views
    100

    Hi interntest, Export tables in VoltDB are...

    Hi interntest,

    Export tables in VoltDB are insert-only and are only buffered in memory until they are loaded by an export connector to a target external data system, which is typically within...
  5. Replies
    2
    Views
    53

    Hi, The supported types for stored procedure...

    Hi,

    The supported types for stored procedure input parameters are documented in Using VoltDB Chapter 5: http://docs.voltdb.com/UsingVoltDB/DesignProcAnatomy.php#DesignPassArgs

    Regards,
    Ben
  6. No, there isn't in Community Edition.

    No, there isn't in Community Edition.
  7. Hi tanker, That document was one that I wrote...

    Hi tanker,

    That document was one that I wrote for use in some in-person training sessions more than two years ago for VoltDB v3.0 and earlier. It is now quite obsolete. Automated snapshots are...
  8. Replies
    3
    Views
    210

    Hello Snowball, Stored procedures are...

    Hello Snowball,

    Stored procedures are pre-compiled and the queries within them are pre-planned, whereas Ad Hoc SQL statements must be parsed and planned on the fly which adds overhead to each...
  9. One other thing to be careful of is to either run...

    One other thing to be careful of is to either run the instances in separate directories and use the default voltdbroot subfolder, or configure the paths in the deployment.xml file to output to...
  10. I put up an example in a branch of one of our...

    I put up an example in a branch of one of our demos: https://github.com/VoltDB/app-nbbo/tree/playback

    Here is the example java client:...
  11. Replies
    3
    Views
    372

    Hi Arthur, I may have misunderstood your...

    Hi Arthur,

    I may have misunderstood your question. I posted this on Stack Overflow as well:

    Data stored in VoltDB (e.g. when you insert records) is stored 100% in RAM and is not compressed....
  12. Replies
    3
    Views
    372

    Hi Arthur, VoltDB uses the Snappy compression...

    Hi Arthur,

    VoltDB uses the Snappy compression algorithm for writing snapshots to disk. Snappy is optimized for speed vs. compression ratio, but the compression is still pretty good. There aren't...
  13. Hi Pavangadiya, Why not do the mathematical...

    Hi Pavangadiya,

    Why not do the mathematical comparison of columns within a query on the database itself? Also, after this comparison is done, what happens with the results, do you need to do...
  14. Hi Pavagadiya, The basic way to iterate with...

    Hi Pavagadiya,

    The basic way to iterate with OFFSET and LIMIT is to increment the OFFSET by the amount of the LIMIT. For example:
    int recordcount;
    //query the count(*) of the table first to get...
  15. Replies
    2
    Views
    150

    Hi Alessandro, Here is the documentation for...

    Hi Alessandro,

    Here is the documentation for the supported DDL statements and their syntax: http://docs.voltdb.com/UsingVoltDB/AppxDDL.php

    The CREATE TABLE statement doesn't support the syntax...
  16. Replies
    1
    Views
    126

    Hi Yiannis, Supposing the query is a GROUP BY...

    Hi Yiannis,

    Supposing the query is a GROUP BY query, and you want to aggregate at regular intervals, you can use a VIEW to make this very efficient. Any regular interval can be made by leveraging...
  17. Replies
    5
    Views
    2,549

    VoltDB uses the TIMESTAMP datatype, which...

    VoltDB uses the TIMESTAMP datatype, which includes date and time. You can insert a date string in the format 'YYYY-MM-DD' into a timestamp datatype column and it will default the time to 00:00:00. ...
  18. Replies
    2
    Views
    212

    In general, this is not recommended for a few...

    In general, this is not recommended for a few reasons:
    - It could cause issues with determinism
    - i/o will slow the execution of the procedure

    It would be better to use export. You could...
  19. Can you provide the rest of the SQL statement? ...

    Can you provide the rest of the SQL statement? Line number 15 is just the line that begins the statement, but the error could be anywhere in the statement.
  20. Hi Arthur, We'd love to help you with a POC. ...

    Hi Arthur,

    We'd love to help you with a POC. This is a question that might be best handled with a discussion. Could you contact me directly to set up a call to go over this.

    I will try to...
  21. Hi Edson, Thanks, we're interested in your...

    Hi Edson,

    Thanks, we're interested in your results. Please ask us to review your tests further if you get lower than expected performance. We're happy to take the conversation private if you...
  22. Hi Edson, It looks like your Test.java class...

    Hi Edson,

    It looks like your Test.java class creates a new client object, connects to one node of VoltDB, calls a single procedure using a synchronous call, then closes the connection.

    VoltDB...
  23. No, you don't need to call drain() before sending...

    No, you don't need to call drain() before sending more requests. In our example applications, drain() is called at the end of the run to ensure that all the responses are received before the...
  24. Hi Stijn, Stefano will assist you. I was...

    Hi Stijn,

    Stefano will assist you. I was typing this earlier and got interrupted, but it may still be useful.

    There isn't a way to call one stored procedure from another. If the work can be...
  25. Replies
    3
    Views
    737

    HD.Users.Boss.voltdb-4.2.voltdb may be a java...

    HD.Users.Boss.voltdb-4.2.voltdb may be a java package name that is somehow inadvertently generated from your directory structure /HD/Users/Boss/voltdb-4.2/voltdb

    It doesn't make sense that this...
Results 1 to 25 of 99
Page 1 of 4 1 2 3 4