Search:

Type: Posts; User: jpiekos

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Thread: VoltDB hangs

    by jpiekos
    Replies
    3
    Views
    35

    Yes, the same setting/directions work for v5.8. ...

    Yes, the same setting/directions work for v5.8. v5.8 did not have a default timeout setting enabled (now v6.0, our latest release, does).

    John
  2. Thread: VoltDB hangs

    by jpiekos
    Replies
    3
    Views
    35

    You can set a query timeout for the database. In...

    You can set a query timeout for the database. In version 6.0 we set a default query timeout of 10 seconds, which will abort any long running read after that amount of time.

    For details on this...
  3. Replies
    3
    Views
    444

    Check out our voter example, in particular this...

    Check out our voter example, in particular this stored procedure: https://github.com/VoltDB/voltdb/blob/master/examples/voter/procedures/voter/ContestantWinningStates.java
    While it does not do...
  4. Replies
    3
    Views
    444

    We do not currently support a regex function. ...

    We do not currently support a regex function. Our SQL column functions are listed here: https://docs.voltdb.com/UsingVoltDB/AppSqlFuncs.php

    One workaround would be to create a stored procedure...
  5. Hi Sharon, Yes, materialized views are updated...

    Hi Sharon,

    Yes, materialized views are updated dynamically when the underlying table data changes, so deleting rows updates the aggregates in the MV.

    We're working on a new view-type that can...
  6. Great! For the record, here is some info on...

    Great! For the record, here is some info on configuring DBVisualizer:

    - Open up the Driver Manager in DBVisualizer.
    - Add a new driver configuration (the + icon)
    - Name: VoltDB
    URL format:...
  7. DBvisualizer works great (never tried dbeaver). ...

    DBvisualizer works great (never tried dbeaver).

    John
  8. Thread: LIcense.

    by jpiekos
    Replies
    1
    Views
    333

    Hi Benny, drop us a note at info@voltdb.com and...

    Hi Benny, drop us a note at info@voltdb.com and we can extend your license.

    Thanks,

    John
  9. Replies
    13
    Views
    2,762

    sub-query support in the IN clause is in our v5.3...

    sub-query support in the IN clause is in our v5.3 release (which is available now on our website). Please upgrade and let us know how it goes.

    Thanks,

    John
  10. Replies
    13
    Views
    2,762

    Hi Anton, Sub queries are only supported in...

    Hi Anton,

    Sub queries are only supported in the SELECT statement at this time.

    For reference, see page: http://docs.voltdb.com/UsingVoltDB/sqlref_select.php

    The SELECT statement supports...
  11. Replies
    1
    Views
    632

    Hi Maxime, You are welcome to use the binary...

    Hi Maxime,

    You are welcome to use the binary client jar under MIT license. Unfortunately, the Maven repo requires us to post source code, so some of the code we had to post is AGPL.

    John
  12. Replies
    5
    Views
    836

    Yes, the VoltDB ODBC driver has been used to...

    Yes, the VoltDB ODBC driver has been used to connect to Excel. We'd be interested in your feedback with using it, and also your use case.

    Thanks,

    John
  13. Replies
    3
    Views
    769

    Step 3 can be run on the same Linux box, but on a...

    Step 3 can be run on the same Linux box, but on a separate terminal window. Or you can run the "voltdb create" in the background ("voltdb create --background" will do it) and run sqlcmd from the...
  14. Replies
    3
    Views
    769

    I'm not familiar with SQLLine, but we've...

    I'm not familiar with SQLLine, but we've successfully run tools such as DBVisualizer and SQuirreL. Check out our voter JDBC sample in the kit for a working example of JDBC:...
  15. Hi Lee, Let's discuss off-line. I'm sure we...

    Hi Lee,

    Let's discuss off-line. I'm sure we can work out something.

    John
  16. Replies
    4
    Views
    2,246

    Yes, we've considered it - can you describe your...

    Yes, we've considered it - can you describe your use case to help me better understand what you are trying to accomplish?
  17. Replies
    15
    Views
    9,628

    We've recently been deploying VoltDB via Docker,...

    We've recently been deploying VoltDB via Docker, which would provide an easy path (at high performance) to running VoltDB on Windows servers. Would that help your deployments?
    Drop me a note to...
  18. Replies
    7
    Views
    2,220

    In v5.0 we're eliminating the catalog. You will...

    In v5.0 we're eliminating the catalog. You will be able to start an empty database and create schema interactively, alter table, etc. Look for a beta by end of November.

    John
  19. Replies
    1
    Views
    1,488

    > FATAL: ZooKeeper service unable to bind to port...

    > FATAL: ZooKeeper service unable to bind to port : 2181

    You have a port collision. Another process is using port 2181.

    John
  20. Replies
    1
    Views
    1,038

    Yes, you can use the catalog report (for...

    Yes, you can use the catalog report (for precompiled queries), or Web Studio, or SQLCMD.

    Check out this blog for Studio and SQLCMD: http://voltdb.com/blog/best-practices/whats-the-plan-2/

    And...
  21. Hi John, VoltDB is very easy to get started...

    Hi John,

    VoltDB is very easy to get started with. At a high level it is very much like a traditional database (SQL, even JDBC or ODBC interfaces). One major difference is that it is a clustered...
  22. Hi XiaoRong, Upgrading from Community to...

    Hi XiaoRong,

    Upgrading from Community to Enterprise, code-wise, is easy, no code conversion needed, simply install the enterprise kit. You can then enable enterprise features such as elasticity,...
  23. Replies
    8
    Views
    5,159

    Hi Frank, Is this on v3.6 or the latest, v4.4?...

    Hi Frank,

    Is this on v3.6 or the latest, v4.4? I think this problem may have been fixed this past March.

    John
  24. Replies
    1
    Views
    1,284

    A lot of this work (triggers, foreign key) can be...

    A lot of this work (triggers, foreign key) can be performed within a stored procedure. These items are in our backlog, medium priority, possible to see them next year.

    John
  25. Thread: VoltDb future

    by jpiekos
    Replies
    1
    Views
    1,980

    Hi Demius, We've got a lot of great things...

    Hi Demius,

    We've got a lot of great things planned for VoltDB in the coming year+. Stay tuned to our VoltDBrief newsletter for the latest information.

    John
Results 1 to 25 of 95
Page 1 of 4 1 2 3 4