It's weird. If I use tinyint, the following exception is thrown when
attempting to create a table
NestedThrowablesStackTrace:
org.h2.jdbc.JdbcSQLException: Data conversion error converting "'N' (SDS:
IS_COMPRESSED TINYINT NOT NULL)"; SQL statement:
INSERT INTO SDS
(SD_ID,INPUT_FORMAT,IS_COMPRESSE
well. There lies your answer. So. what you might consider doing is
altering that table column and change it to tinyint. That might be just
enough to trick it since i think the java code is expecting either a 0 or 1
- not 'false'.
might be worth a try.
On Mon, Jun 3, 2013 at 5:47 PM, Jamal B w
It treats it as a boolean.
http://www.h2database.com/html/datatypes.html#boolean_type
On Mon, Jun 3, 2013 at 8:16 PM, Stephen Sprague wrote:
> it does. so its a bit datatype. that's a tad non-standard i'd say. what
> does your backend store (H2) do with that?
>
> {code}
> | SDS | CREATE T
it does. so its a bit datatype. that's a tad non-standard i'd say. what
does your backend store (H2) do with that?
{code}
| SDS | CREATE TABLE `SDS` (
`SD_ID` bigint(20) NOT NULL,
`INPUT_FORMAT` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin
DEFAULT NULL,
`IS_COMPRESSED` bit(1) N
I gave that a shot, but it didn't work. Could you run a describe table to
see if it matches this schema (assuming mysql):
--
-- Table structure for table `SDS`
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE IF NOT EXIST
not that this is any consolation but on my mysql instance, same cdh
release, i have the following for IS_COMPRESSED where you have 'false':
{code}
{metastore@etl1 root 13:13}>select SD_ID, is_compressed from SDS limit 10;
+---+---+
| SD_ID | is_compressed |
+---+---
