Does Marketo support bigint data type? The data will be coming from Hadoop
Solved! Go to Solution.
Simply put: No. Integers are signed 32-bit. Scores, though misdocumented as if they're signed 64-bit, cannot be updated beyond 32-bit via API.
But I wonder what you're expecting to do with these 64-bit types. If you only need to store them in Marketo and output them in emails, you can use a String, although that won't allow you to use them in numeric filters. Using a String will, perhaps surprisingly, allow you to treat them as BigIntegers in emails (i.e. you can add/subtract/whatever with them) because Velocity can cast a String to a BigInt.
Simply put: No. Integers are signed 32-bit. Scores, though misdocumented as if they're signed 64-bit, cannot be updated beyond 32-bit via API.
But I wonder what you're expecting to do with these 64-bit types. If you only need to store them in Marketo and output them in emails, you can use a String, although that won't allow you to use them in numeric filters. Using a String will, perhaps surprisingly, allow you to treat them as BigIntegers in emails (i.e. you can add/subtract/whatever with them) because Velocity can cast a String to a BigInt.