Search:

Type: Posts; User: bballard

Page 1 of 7 1 2 3 4

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    27

    Just to clarify: - You can use automated...

    Just to clarify:
    - You can use automated snapshots with a 30m frequency, but the timing is based on when the database was started, not every hour on the 00 and 30 minute marks. There is NOT...
  2. Replies
    1
    Views
    21

    Hi Sabrina, The SQL permission does not in...

    Hi Sabrina,

    The SQL permission does not in fact include DDL. To execute DDL, the user should have the "administrator" default role.

    The documentation incorrectly lists "DDL" as part of the SQL...
  3. Replies
    2
    Views
    120

    Hi Sabrina, There is an intentional delay in...

    Hi Sabrina,

    There is an intentional delay in accepting connections for security purposes. We are using org.mindrot.BCrypt class to verify passwords, which purposely uses slow hashing to avoid...
  4. Replies
    8
    Views
    511

    Hi, To control the process of which files to...

    Hi,

    To control the process of which files to load when, and check their success from Python, probably the subprocess method would work. Test using csvloader from the command line and you will see...
  5. Replies
    8
    Views
    511

    Hi, VoltDB doesn't have anything similar to...

    Hi,

    VoltDB doesn't have anything similar to PostreSQL's "COPY" syntax where you can load csv files with a SQL statement.

    You should not try to run csvloader from within a stored procedure. ...
  6. Most of our customers use VoltDB as a fast...

    Most of our customers use VoltDB as a fast ingestion system of record, and then use Export (https://docs.voltdb.com/UsingVoltDB/ChapExport.php) to push records to downstream data systems, including...
  7. Replies
    8
    Views
    511

    The csvloader utility is implemented in java, so...

    The csvloader utility is implemented in java, so it is possible to invoke it directly from a java application. The csvloader bin script just sets some environment variable and then calls the...
  8. Replies
    1
    Views
    225

    Hi Wayne, Power is not a supported platform. ...

    Hi Wayne,

    Power is not a supported platform. We support 64-bit Linux on Intel architecture, and we have a development build for Mac OS X which is also Intel architecture.

    If you look in the...
  9. A procedure is either partitioned or not. If it...

    A procedure is either partitioned or not. If it is partitioned, the value of the parameter is what determines which partition it will run in. Once there, the database will check against illegal...
  10. Specifically in answer to your questions, the...

    Specifically in answer to your questions, the syntax for partioning a procedure requires a table and column name, but also can have a PARAMETER index number which is optional because it defaults to 0...
  11. This is an astute question. While the most...

    This is an astute question. While the most common case is as you mentioned, where the partition on <tablename> column <columname> in the DDL to corresponds to "SELECT * FROM <tablename> WHERE...
  12. Hi ThatDud3, It turns out what I wrote is not...

    Hi ThatDud3,

    It turns out what I wrote is not correct. You can pass in a JSON representation of a VoltTable over the REST API when calling a procedure that has a VoltTable input parameter.

    To...
  13. There is no way to pass in a VoltTable input...

    There is no way to pass in a VoltTable input parameter via the REST API. When you call the REST API, the values are passed in a strings to the procedure, and these are converted to the primitive...
  14. Replies
    6
    Views
    1,556

    The default procedures such as TABLENAME.insert...

    The default procedures such as TABLENAME.insert are generated for each table in the database, so the database knows if the tables are partitioned and whether to also partition these procedures, and...
  15. Csvloader uses a bulk loader mechanism by...

    Csvloader uses a bulk loader mechanism by default, if you only specify the table name. If you specify a procedure with the "-p" parameter, it will call the procedure instead.

    The default...
  16. Replies
    2
    Views
    374

    Optionally, if using Kerberos authentication,...

    Optionally, if using Kerberos authentication, each host in the cluster has a keytab file and uses Java Cryptography Extension (JCE) with the Java Authentication and Authorization Service (JAAS) to...
  17. Hi Pavan, VoltTable is a java object, which...

    Hi Pavan,

    VoltTable is a java object, which has no persistence. You can certainly use a "while (t.advanceRow()) {...}" loop in a java stored procedure to iterate through the rows of a VoltTable...
  18. Hi, Stored procedures need to be explicitly...

    Hi,

    Stored procedures need to be explicitly partitioned in the DDL. This can be done with the PARTITION PROCEDURE syntax, or directly with CREATE PROCEDURE [PARTITION ON ...] ...

    When running...
  19. If you run 3 SQL statements within a procedure,...

    If you run 3 SQL statements within a procedure, they are executed one at a time. If you run them as separate calls to the database, if they are multi-partition, each request will be put into the...
  20. VoltDB is architected to use 100% main memory for...

    VoltDB is architected to use 100% main memory for data, as it's intended for fast transaction processing.

    Many fast data problems will fit in main memory, and in many cases that seem to require...
  21. Replies
    3
    Views
    629

    Hi, No problem. Out of curiosity, are you...

    Hi,

    No problem. Out of curiosity, are you working on an academic research project? What are you trying to accomplish?

    Thanks,
    Ben
  22. Replies
    4
    Views
    729

    Hi, the VoltDB University video on Replication is...

    Hi, the VoltDB University video on Replication is in the process of being updated. The DR Agent is no longer used for Database Replication as of version 5.1 and later.

    Thanks!
  23. Replies
    3
    Views
    444

    Just to add a bit about JMeter, we don't have...

    Just to add a bit about JMeter, we don't have much experience or expertise with it. I have used it once, with the JDBC driver to call stored procedures. In the links Peter gave you for our example...
  24. Replies
    2
    Views
    391

    There is an in-memory undo log for the current...

    There is an in-memory undo log for the current write transaction.
  25. There is a multi-partition initiator (MPI) that...

    There is a multi-partition initiator (MPI) that does the global ordering. It has a thread for coordinating write transactions, and a pool of threads for coordinating read transactions, sending query...
Results 1 to 25 of 174
Page 1 of 7 1 2 3 4