Skip to content

Instantly share code, notes, and snippets.

@PMeinshausen

PMeinshausen/ConfusionMatrix.sql

Created September 18, 2014 11:59
Show Gist options
  • Save PMeinshausen/9bba8d071aa79ee4aec3 to your computer and use it in GitHub Desktop.
Save PMeinshausen/9bba8d071aa79ee4aec3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ConfusionMatrix.sql
--Syntax (version 1.1)
select * from ConfusionMatrix(
ON {table_name|view_name|(query)} PARTITION BY <expect_column_name>
EXPECTCOLUMN('expect_column_name')
PREDICTCOLUMN('result_column_name')
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment