0

Boolean Data Type in Schema

When importing data in a Schema, I've noticed there is no data type for boolean or bit available.  I know this is a  simple question but have not seen any documentation, questions, or other information this.  When loading data that has a bit column, the data type detected is set as string with values in {0,1}.  Should the data type be set to integer to allow for faster value comparisons or does that not matter in Incorta?  Or is a boolean data type available and I am missing something?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Joe - Boolean datatype is not available so try and select INT as the datatype as it has a better load performance than string  and see if you get 0 or 1 values.

    Reply Like
    • Amit Kothari INT works fine.  I assumed string comparisons were going to be slower which is why I asked.  Just a thought, but if a BIT data type from SQL comes across when creating Schema, perhaps set Incorta up to default to INT instead of STRING.  Not a big deal to change on my side obviously.  Thank you for your response.

      Reply Like
    • Joe Steinbrunner  I agree.

      Reply Like
Like Follow
  • Status Answered
  • 1 mth agoLast active
  • 3Replies
  • 21Views
  • 2 Following