https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142406#M48247 <P>Awesome support, thanks!</P> Thu, 08 Dec 2016 06:04:51 GMT ashsskum 2016-12-08T06:04:51Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142404#M48245 <P>Per documentation, the type of each Parameter is to expected to an integer value that represents the JDBC Type.</P><P>hiveql.args.N.type</P><P>What are the JDBC numeral type value for the following data types and can you please advise where the corresponding documentation can be found?</P><P style="margin-left: 20px;">INTEGER</P><P style="margin-left: 20px;">TIMESTAMP</P><P style="margin-left: 20px;">DOUBLE</P><P style="margin-left: 20px;">LONGVARCHAR</P> Thu, 08 Dec 2016 05:48:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142404#M48245 ashsskum 2016-12-08T05:48:32Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142405#M48246 <P>There is a table for JDBC type values <A target="_blank" href="http://docs.oracle.com/javase/8/docs/api/constant-values.html#java.sql.Types.BIT">here</A>, for your data types they are as follows:</P><TABLE><TBODY><TR><TD><STRONG>Type</STRONG></TD><TD><STRONG>Value</STRONG></TD></TR><TR><TD>INTEGER</TD><TD>4</TD></TR><TR><TD>TIMESTAMP</TD><TD>93</TD></TR><TR><TD>DOUBLE</TD><TD>8</TD></TR><TR><TD>LONGVARCHAR</TD><TD>-1</TD></TR></TBODY></TABLE> Thu, 08 Dec 2016 05:56:30 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142405#M48246 mburgess 2016-12-08T05:56:30Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142406#M48247 <P>Awesome support, thanks!</P> Thu, 08 Dec 2016 06:04:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NiFi-PutHiveQL-processor-properties/m-p/142406#M48247 ashsskum 2016-12-08T06:04:51Z