Search:

Type: Posts; User: pzhao

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Zhangbm, I've answered your question here...

    Zhangbm,

    I've answered your question here.

    Peter Zhao
  2. Replies
    1
    Views
    31

    Zhangbm, I'd be happy to help you. I think the...

    Zhangbm,

    I'd be happy to help you. I think the first thing to do is upgrade to the latest version of Voltdb via github. Yes, you can deploy a cluster with VoltDB community version. Can you provide...
  3. Replies
    1
    Views
    53

    Pavan, Please refer to this link...

    Pavan,

    Please refer to this link for increasing temp table memory in VoltDB.

    Peter Zhao
  4. Replies
    4
    Views
    100

    Interntest, VoltDB has a capped collection via...

    Interntest,

    VoltDB has a capped collection via create table's limit constraint. More information is located here.

    Q1: Correct, it is not in memory. Just a clarification, export tables are...
  5. Guotong, Sounds like your all set but if you...

    Guotong,

    Sounds like your all set but if you need assistance, please reach out to us.

    Peter Zhao
  6. Stepaneko, Unfortunately, this is not a...

    Stepaneko,

    Unfortunately, this is not a currently feature. We will consider this in a future release.

    Peter Zhao
  7. Replies
    1
    Views
    133

    Arthurz, The specific section you are...

    Arthurz,

    The specific section you are referring to is about manual backups. Automated Snapshots can be configured via deployment file. Please look at this.

    Peter Zhao
  8. Pavagadiya, In addition to using filters, you...

    Pavagadiya,

    In addition to using filters, you can also use limit/offset to divide up the data. Here is the documentation.
  9. Pavangadiya, Currently, VoltDB has limitations...

    Pavangadiya,

    Currently, VoltDB has limitations on large data sets but will improve in the coming months. As a workaround you can break up the query and divide the data using filters. Breaking up...
  10. Replies
    3
    Views
    229

    Alessandro, Please take a look at the bottom...

    Alessandro,

    Please take a look at the bottom of @Statistics.
    You'll find some sample code that calls @Statistics and try the MEMORY parameter. See if that helps.

    Peter Zhao
  11. Replies
    3
    Views
    229

    Alessandro, We do not have SQL statement style...

    Alessandro,

    We do not have SQL statement style syntax as you've described. Besides using stored procedure or our VMC, you can also use sqlcmd tool:
    echo "exec @statistics memory, 0;" | sqlcmd
    ...
  12. Duydx, When you develop stored procedures, you...

    Duydx,

    When you develop stored procedures, you must decide if they are to be partitioned or not, in which case it will run as a multi-partition transaction. If the procedure needs to access data...
  13. Replies
    1
    Views
    344

    Duydx, Doumentation (http://docs.voltdb.com/)...

    Duydx,

    Doumentation for VoltDB contains alot of the information you are looking for. There is also a search if you need to find something specific. If you find something you need further help on,...
  14. Replies
    2
    Views
    213

    duydx, Did you do jar the class files after...

    duydx,

    Did you do jar the class files after javac? It appears you were able to compile properly using javac. I was able to compile your code properly as well.
    Here is a guide on...
  15. Gopals, I suspect there is more to the crash...

    Gopals,

    I suspect there is more to the crash then just this warning message. Within your working directory, there should be a log/volt.log file present you can check.
    Alternatively, you can run...
  16. Gopals, Added, you could define row limits on...

    Gopals,

    Added, you could define row limits on tables to prevent over utilizing heap size.

    Peter
  17. GopalS, Ultimately, an undersized Java heap...

    GopalS,

    Ultimately, an undersized Java heap memory (VOLTDB_HEAPMAX) leads to VoltDB crashing due to not enough heap memory or VoltDB performance will suffer due to java garbage collection being...
  18. Replies
    8
    Views
    1,590

    Challagal, My name is Peter from VoltDB. I'd...

    Challagal,

    My name is Peter from VoltDB. I'd love to help you out with your setup.

    Suggestions/questions:
    What version of voltdb is being run?
    Try simpler setup to just prove that,voltdb is...
  19. Replies
    5
    Views
    440

    Sirin, One suggestion is to check if swapping...

    Sirin,

    One suggestion is to check if swapping is enabled using the command 'swapon -s'. Memory swapping is enabled by default for most linux distributions and hinder VoltDB performance.

    Here...
  20. Replies
    5
    Views
    440

    Sirin, Thanks for your response. Could you do...

    Sirin,

    Thanks for your response. Could you do a simple count(*) on your 'store' table just to verify the row count?
    Added, would it be possible to send us all the necessary files via zip so that...
  21. Replies
    5
    Views
    440

    Sirin, I think our best approach here is to...

    Sirin,

    I think our best approach here is to reproduce this problem. Just a few questions/information I'd like to gather:

    After 1.6billion rows, can you validate that there are indeed values...
  22. Replies
    1
    Views
    237

    Duydx, Can you send show me your deployment...

    Duydx,

    Can you send show me your deployment file? It appears the userid is not present in your deployment.xml file.
  23. Replies
    2
    Views
    490

    Racerx, There are 2 things you could do. One...

    Racerx,

    There are 2 things you could do. One option is to put callprocedure1/callprocedure2/dootherimportantthings in one stored procedure. This will either all succeed or all fail. The other...
  24. Replies
    2
    Views
    537

    Ghalia, It seems like the port being used is...

    Ghalia,

    It seems like the port being used is either not listening or being used for something else, ie another application.
    Please verify that voltdb is running, ie 'ps aux | grep voltdb' or...
  25. Replies
    3
    Views
    645

    Thiago, Sorry for the late reply to your...

    Thiago,

    Sorry for the late reply to your question.

    Here is a quick example of assumeunique index:
    CREATE TABLE T38
    (
    C INTEGER
    C6 DECIMAL ASSUMEUNIQUE NOT NULL
    , CONSTRAINT...
Results 1 to 25 of 36
Page 1 of 2 1 2