+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    12

    What's with file 'ab_switch'?

    Hey Guys,

    Here is my case,
    1. create a table called test. --- for now, there is no ab_switch unter folder test.bht.
    2. load data into table test. --- for now, there is still no ab_switch unter folder test.bht.
    3. load data into table test again. --- for now, ab_switch appeares.
    4. load data into table test one more time. --- for now, ab_switch disappear.
    5. load data into table test again. --- for now, ab_switch appeares.
    6. load data into table test one more time. --- for now, ab_switch disappear.
    ... ...
    Seems like the file ab_switch appears even on several occasions.
    Could anyone tell me what is ab_switch? Why it has a such strange life cycle?


    Thanks,
    Satine

  2. #2
    Junior Member
    Join Date
    Sep 2013
    Posts
    15
    hi Satine, were you able to figure that out?
    sad, that there is no reply to such an interesting question..

    Thanks,
    sopeti

  3. #3
    Junior Member
    Join Date
    Sep 2013
    Posts
    15
    Ok,
    based on the info present in https://support.infobright.com/forum...-.ctb-question
    it looks the ab_switch might be used to identify whether to write on *00.ctb or *01.ctb files.

  4. #4
    There are multiple kinds of files that we write to disk for many different reason. Things like the Knowledge Grid have their own files, but also spawn into additional files depending upon the query you are running. Certain types of Pack to Pack nodes are necessary for complex Joins. Also depending upon the type of data the column is, there may be additional data pack nodes. Does this answer the question?

  5. #5
    Junior Member
    Join Date
    Sep 2013
    Posts
    15
    Got it! Thanks, Craig

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts