spotfire cannot read boolean type in Hadoop
hi There
we have some columns which is boolean type and i noticed when i tried to build table from those columns, spotfire cannot recognize them, however boolean from sql server has no issue in spotfire
does anyone know how to fix it?
thanks
Cleo
Oct 16, 2018 - 12:20pm
chunlai.tao
+ Add a Comment
(1) Answer
Hello,
How are you sourcing the data ,is it connectors or information links?If information links can you please share the jdbc template in use?
1 Comment
<jdbc-type-settings>
<type-name>hive2</type-name>
<driver>org.apache.hive.jdbc.HiveDriver</driver>
<connection-url-pattern>
jdbc:hive2://<host>:<port10000>/<database>
</connection-url-pattern>
<supports-catalogs>false</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<ping-command>SHOW TABLES</ping-command>
<column-name-pattern>`$$name$$`</column-name-pattern>
<table-name-pattern>`$$name$$`</table-name-pattern>
<schema-name-pattern>`$$name$$`</schema-name-pattern>
<catalog-name-pattern>`$$name$$`</catalog-name-pattern>
<procedure-name-pattern>`$$name$$`</procedure-name-pattern>
<column-alias-pattern>`$$name$$`</column-alias-pattern>
</jdbc-type-settings>
Flag for Review
Nov 15, 2018 - 3:21pm
Sayali Patil 1 Comment
<jdbc-type-settings>
<type-name>hive2</type-name>
<driver>org.apache.hive.jdbc.HiveDriver</driver>
<connection-url-pattern>
jdbc:hive2://<host>:<port10000>/<database>
</connection-url-pattern>
<supports-catalogs>false</supports-catalogs>
<supports-schemas>true</supports-schemas>
<supports-procedures>false</supports-procedures>
<ping-command>SHOW TABLES</ping-command>
<column-name-pattern>`$$name$$`</column-name-pattern>
<table-name-pattern>`$$name$$`</table-name-pattern>
<schema-name-pattern>`$$name$$`</schema-name-pattern>
<catalog-name-pattern>`$$name$$`</catalog-name-pattern>
<procedure-name-pattern>`$$name$$`</procedure-name-pattern>
<column-alias-pattern>`$$name$$`</column-alias-pattern>
</jdbc-type-settings>