DROP TABLE IF EXISTS kmodes_clusters1; SELECT * FROM kmodes ( ON (SELECT 1) PARTITION BY 1 InputTable ('kmodes_input ') NumClusters ('3') OutputTable ('kmodes_clusters1 ') InputColumns ('mpg:carb') AsCategories ('cyl', 'gear', 'carb') );
DROP TABLE IF EXISTS kmodes_clusters1; SELECT * FROM kmodes ( ON (SELECT 1) PARTITION BY 1 InputTable ('kmodes_input ') NumClusters ('3') OutputTable ('kmodes_clusters1 ') InputColumns ('mpg:carb') AsCategories ('cyl', 'gear', 'carb') );