https://community.cloudera.com/t5/Support-Questions/BigQuery-schema-issue/m-p/280947#M209064 <P>HI</P><P>I am using the nifi processor&nbsp;<SPAN>PutBigQueryBatch to put data into a Google Cloud BigQuery table.</SPAN></P><P><SPAN>However, I am getting the below error with regards to the schema I have defined in the properties</SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BigQuery Schema Error.PNG" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/24990i7555AFFA226E9530/image-size/medium?v=v2&amp;px=400" role="button" title="BigQuery Schema Error.PNG" alt="BigQuery Schema Error.PNG" /></span></SPAN></P><P>&nbsp;</P><P><SPAN>Below is the schema definition I have in the properties of the&nbsp;</SPAN>process</P><P><SPAN>[<BR />{<BR />"name": "checknumber",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Altertions",<BR />"type": "RECORD",<BR />"mode": "REPEATED",<BR />"fields": [<BR />{<BR />"name": "Alteration_Product_Qty",<BR />"type": "FLOAT",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Alteration_Product_Name",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Altered_Product_Name",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Alteration_Product_Code",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Altered_Product_Code",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Alteration_Product_Net_Amount",<BR />"type": "FLOAT",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Alteration_Product_Amount",<BR />"type": "FLOAT",<BR />"mode": "NULLABLE"<BR />}<BR />]<BR />},<BR />{<BR />"name": "dob",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "StoreId",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Order_Mode_Id",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "checkClosetime",<BR />"type": "TIMESTAMP",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Revenue_Id",<BR />"type": "INTEGER",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Alteration_Flag",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Revenue_Label",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "Order_Mode_Label",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />},<BR />{<BR />"name": "StoreName",<BR />"type": "STRING",<BR />"mode": "NULLABLE"<BR />}<BR />]</SPAN></P><P>&nbsp;</P><P>and here is the definition of the table in BigQuery</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BigQuery Schema Definition.PNG" style="width: 363px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/24991i80FD693476A307A3/image-size/medium?v=v2&amp;px=400" role="button" title="BigQuery Schema Definition.PNG" alt="BigQuery Schema Definition.PNG" /></span></P><P>&nbsp;</P><P>I think it has something to do with how I have defined the Alterations array in the properties but can't figure out what.</P><P>Does anyone know how to define the array correctly in the schema definition in the properties of the&nbsp;<SPAN>PutBigQueryBatch process?</SPAN></P><P>&nbsp;</P><P><SPAN>Thanks</SPAN></P><P><SPAN>Tim</SPAN></P> Mon, 21 Oct 2019 22:44:39 GMT TimManger 2019-10-21T22:44:39Z