Hive Data source connection with Spotfire

Use JDBC connection to connect Hive database

jdbc:hive2://server.xx.net:8443/57_5383188;ssl=true;transportMode=http;httpPath=gateway/default/hive;?tez.queue.name=adhoc;

Hive commands

https://www.edureka.co/blog/hive-commands-with-examples

Executing Python Script based on Marking Selection

Suggested by Tibco

http://bispotfire.blogspot.se/2015/06/executing-python-script-based-on.html

Selected value in Spotfire multi select property control using JQuery

$("#1f26c088453c4877a82e02b276e6fdf1").val("Select").change(); 

JQuery to validate Spotfire Multiselect control and limit MultiSelect with JQuery alert

$("#1f26c088453c4877a82e02b276e6fdf1").change(function()
{
var type1= $("#e8b0e6f9534f4e4c9eb263d3696b367c").text();
var type2= $("#1f26c088453c4877a82e02b276e6fdf1 option:selected").text();
var options = $('#1f26c088453c4877a82e02b276e6fdf1 > option:selected');
         if(options.length > 3){
             alert('We currently provide a comparison for three types.  You have selected more than three; therefore you will need to update your selections in order to move forward.');
             return false;
         }

if(type2.indexOf(type1)>-1){

             alert('One of your selections is the same type as your main selection. Please select a different type to compare.');
$('#1f26c088453c4877a82e02b276e6fdf1').val("0");
             return false;
         }

    });