Google Git
Sign in
apache / impala / 0511b44f9236c655e695185b33f412ec65a80a07 / . / testdata / workloads / functional-query / queries / QueryTest / sort.test
blob: 0fe7efa12d6df904416841c3a2b581df1fedcc3c [file] [log] [blame]
====
---- QUERY
# order by a variable length column
select
string_col,
date_string_col
from
alltypes
order by
string_col,
date_string_col
limit 1000
---- RESULTS
'0','01/01/09'
'0','01/01/10'
'0','01/02/09'
'0','01/02/10'
'0','01/03/09'
'0','01/03/10'
'0','01/04/09'
'0','01/04/10'
'0','01/05/09'
'0','01/05/10'
'0','01/06/09'
'0','01/06/10'
'0','01/07/09'
'0','01/07/10'
'0','01/08/09'
'0','01/08/10'
'0','01/09/09'
'0','01/09/10'
'0','01/10/09'
'0','01/10/10'
'0','01/11/09'
'0','01/11/10'
'0','01/12/09'
'0','01/12/10'
'0','01/13/09'
'0','01/13/10'
'0','01/14/09'
'0','01/14/10'
'0','01/15/09'
'0','01/15/10'
'0','01/16/09'
'0','01/16/10'
'0','01/17/09'
'0','01/17/10'
'0','01/18/09'
'0','01/18/10'
'0','01/19/09'
'0','01/19/10'
'0','01/20/09'
'0','01/20/10'
'0','01/21/09'
'0','01/21/10'
'0','01/22/09'
'0','01/22/10'
'0','01/23/09'
'0','01/23/10'
'0','01/24/09'
'0','01/24/10'
'0','01/25/09'
'0','01/25/10'
'0','01/26/09'
'0','01/26/10'
'0','01/27/09'
'0','01/27/10'
'0','01/28/09'
'0','01/28/10'
'0','01/29/09'
'0','01/29/10'
'0','01/30/09'
'0','01/30/10'
'0','01/31/09'
'0','01/31/10'
'0','02/01/09'
'0','02/01/10'
'0','02/02/09'
'0','02/02/10'
'0','02/03/09'
'0','02/03/10'
'0','02/04/09'
'0','02/04/10'
'0','02/05/09'
'0','02/05/10'
'0','02/06/09'
'0','02/06/10'
'0','02/07/09'
'0','02/07/10'
'0','02/08/09'
'0','02/08/10'
'0','02/09/09'
'0','02/09/10'
'0','02/10/09'
'0','02/10/10'
'0','02/11/09'
'0','02/11/10'
'0','02/12/09'
'0','02/12/10'
'0','02/13/09'
'0','02/13/10'
'0','02/14/09'
'0','02/14/10'
'0','02/15/09'
'0','02/15/10'
'0','02/16/09'
'0','02/16/10'
'0','02/17/09'
'0','02/17/10'
'0','02/18/09'
'0','02/18/10'
'0','02/19/09'
'0','02/19/10'
'0','02/20/09'
'0','02/20/10'
'0','02/21/09'
'0','02/21/10'
'0','02/22/09'
'0','02/22/10'
'0','02/23/09'
'0','02/23/10'
'0','02/24/09'
'0','02/24/10'
'0','02/25/09'
'0','02/25/10'
'0','02/26/09'
'0','02/26/10'
'0','02/27/09'
'0','02/27/10'
'0','02/28/09'
'0','02/28/10'
'0','03/01/09'
'0','03/01/10'
'0','03/02/09'
'0','03/02/10'
'0','03/03/09'
'0','03/03/10'
'0','03/04/09'
'0','03/04/10'
'0','03/05/09'
'0','03/05/10'
'0','03/06/09'
'0','03/06/10'
'0','03/07/09'
'0','03/07/10'
'0','03/08/09'
'0','03/08/10'
'0','03/09/09'
'0','03/09/10'
'0','03/10/09'
'0','03/10/10'
'0','03/11/09'
'0','03/11/10'
'0','03/12/09'
'0','03/12/10'
'0','03/13/09'
'0','03/13/10'
'0','03/14/09'
'0','03/14/10'
'0','03/15/09'
'0','03/15/10'
'0','03/16/09'
'0','03/16/10'
'0','03/17/09'
'0','03/17/10'
'0','03/18/09'
'0','03/18/10'
'0','03/19/09'
'0','03/19/10'
'0','03/20/09'
'0','03/20/10'
'0','03/21/09'
'0','03/21/10'
'0','03/22/09'
'0','03/22/10'
'0','03/23/09'
'0','03/23/10'
'0','03/24/09'
'0','03/24/10'
'0','03/25/09'
'0','03/25/10'
'0','03/26/09'
'0','03/26/10'
'0','03/27/09'
'0','03/27/10'
'0','03/28/09'
'0','03/28/10'
'0','03/29/09'
'0','03/29/10'
'0','03/30/09'
'0','03/30/10'
'0','03/31/09'
'0','03/31/10'
'0','04/01/09'
'0','04/01/10'
'0','04/02/09'
'0','04/02/10'
'0','04/03/09'
'0','04/03/10'
'0','04/04/09'
'0','04/04/10'
'0','04/05/09'
'0','04/05/10'
'0','04/06/09'
'0','04/06/10'
'0','04/07/09'
'0','04/07/10'
'0','04/08/09'
'0','04/08/10'
'0','04/09/09'
'0','04/09/10'
'0','04/10/09'
'0','04/10/10'
'0','04/11/09'
'0','04/11/10'
'0','04/12/09'
'0','04/12/10'
'0','04/13/09'
'0','04/13/10'
'0','04/14/09'
'0','04/14/10'
'0','04/15/09'
'0','04/15/10'
'0','04/16/09'
'0','04/16/10'
'0','04/17/09'
'0','04/17/10'
'0','04/18/09'
'0','04/18/10'
'0','04/19/09'
'0','04/19/10'
'0','04/20/09'
'0','04/20/10'
'0','04/21/09'
'0','04/21/10'
'0','04/22/09'
'0','04/22/10'
'0','04/23/09'
'0','04/23/10'
'0','04/24/09'
'0','04/24/10'
'0','04/25/09'
'0','04/25/10'
'0','04/26/09'
'0','04/26/10'
'0','04/27/09'
'0','04/27/10'
'0','04/28/09'
'0','04/28/10'
'0','04/29/09'
'0','04/29/10'
'0','04/30/09'
'0','04/30/10'
'0','05/01/09'
'0','05/01/10'
'0','05/02/09'
'0','05/02/10'
'0','05/03/09'
'0','05/03/10'
'0','05/04/09'
'0','05/04/10'
'0','05/05/09'
'0','05/05/10'
'0','05/06/09'
'0','05/06/10'
'0','05/07/09'
'0','05/07/10'
'0','05/08/09'
'0','05/08/10'
'0','05/09/09'
'0','05/09/10'
'0','05/10/09'
'0','05/10/10'
'0','05/11/09'
'0','05/11/10'
'0','05/12/09'
'0','05/12/10'
'0','05/13/09'
'0','05/13/10'
'0','05/14/09'
'0','05/14/10'
'0','05/15/09'
'0','05/15/10'
'0','05/16/09'
'0','05/16/10'
'0','05/17/09'
'0','05/17/10'
'0','05/18/09'
'0','05/18/10'
'0','05/19/09'
'0','05/19/10'
'0','05/20/09'
'0','05/20/10'
'0','05/21/09'
'0','05/21/10'
'0','05/22/09'
'0','05/22/10'
'0','05/23/09'
'0','05/23/10'
'0','05/24/09'
'0','05/24/10'
'0','05/25/09'
'0','05/25/10'
'0','05/26/09'
'0','05/26/10'
'0','05/27/09'
'0','05/27/10'
'0','05/28/09'
'0','05/28/10'
'0','05/29/09'
'0','05/29/10'
'0','05/30/09'
'0','05/30/10'
'0','05/31/09'
'0','05/31/10'
'0','06/01/09'
'0','06/01/10'
'0','06/02/09'
'0','06/02/10'
'0','06/03/09'
'0','06/03/10'
'0','06/04/09'
'0','06/04/10'
'0','06/05/09'
'0','06/05/10'
'0','06/06/09'
'0','06/06/10'
'0','06/07/09'
'0','06/07/10'
'0','06/08/09'
'0','06/08/10'
'0','06/09/09'
'0','06/09/10'
'0','06/10/09'
'0','06/10/10'
'0','06/11/09'
'0','06/11/10'
'0','06/12/09'
'0','06/12/10'
'0','06/13/09'
'0','06/13/10'
'0','06/14/09'
'0','06/14/10'
'0','06/15/09'
'0','06/15/10'
'0','06/16/09'
'0','06/16/10'
'0','06/17/09'
'0','06/17/10'
'0','06/18/09'
'0','06/18/10'
'0','06/19/09'
'0','06/19/10'
'0','06/20/09'
'0','06/20/10'
'0','06/21/09'
'0','06/21/10'
'0','06/22/09'
'0','06/22/10'
'0','06/23/09'
'0','06/23/10'
'0','06/24/09'
'0','06/24/10'
'0','06/25/09'
'0','06/25/10'
'0','06/26/09'
'0','06/26/10'
'0','06/27/09'
'0','06/27/10'
'0','06/28/09'
'0','06/28/10'
'0','06/29/09'
'0','06/29/10'
'0','06/30/09'
'0','06/30/10'
'0','07/01/09'
'0','07/01/10'
'0','07/02/09'
'0','07/02/10'
'0','07/03/09'
'0','07/03/10'
'0','07/04/09'
'0','07/04/10'
'0','07/05/09'
'0','07/05/10'
'0','07/06/09'
'0','07/06/10'
'0','07/07/09'
'0','07/07/10'
'0','07/08/09'
'0','07/08/10'
'0','07/09/09'
'0','07/09/10'
'0','07/10/09'
'0','07/10/10'
'0','07/11/09'
'0','07/11/10'
'0','07/12/09'
'0','07/12/10'
'0','07/13/09'
'0','07/13/10'
'0','07/14/09'
'0','07/14/10'
'0','07/15/09'
'0','07/15/10'
'0','07/16/09'
'0','07/16/10'
'0','07/17/09'
'0','07/17/10'
'0','07/18/09'
'0','07/18/10'
'0','07/19/09'
'0','07/19/10'
'0','07/20/09'
'0','07/20/10'
'0','07/21/09'
'0','07/21/10'
'0','07/22/09'
'0','07/22/10'
'0','07/23/09'
'0','07/23/10'
'0','07/24/09'
'0','07/24/10'
'0','07/25/09'
'0','07/25/10'
'0','07/26/09'
'0','07/26/10'
'0','07/27/09'
'0','07/27/10'
'0','07/28/09'
'0','07/28/10'
'0','07/29/09'
'0','07/29/10'
'0','07/30/09'
'0','07/30/10'
'0','07/31/09'
'0','07/31/10'
'0','08/01/09'
'0','08/01/10'
'0','08/02/09'
'0','08/02/10'
'0','08/03/09'
'0','08/03/10'
'0','08/04/09'
'0','08/04/10'
'0','08/05/09'
'0','08/05/10'
'0','08/06/09'
'0','08/06/10'
'0','08/07/09'
'0','08/07/10'
'0','08/08/09'
'0','08/08/10'
'0','08/09/09'
'0','08/09/10'
'0','08/10/09'
'0','08/10/10'
'0','08/11/09'
'0','08/11/10'
'0','08/12/09'
'0','08/12/10'
'0','08/13/09'
'0','08/13/10'
'0','08/14/09'
'0','08/14/10'
'0','08/15/09'
'0','08/15/10'
'0','08/16/09'
'0','08/16/10'
'0','08/17/09'
'0','08/17/10'
'0','08/18/09'
'0','08/18/10'
'0','08/19/09'
'0','08/19/10'
'0','08/20/09'
'0','08/20/10'
'0','08/21/09'
'0','08/21/10'
'0','08/22/09'
'0','08/22/10'
'0','08/23/09'
'0','08/23/10'
'0','08/24/09'
'0','08/24/10'
'0','08/25/09'
'0','08/25/10'
'0','08/26/09'
'0','08/26/10'
'0','08/27/09'
'0','08/27/10'
'0','08/28/09'
'0','08/28/10'
'0','08/29/09'
'0','08/29/10'
'0','08/30/09'
'0','08/30/10'
'0','08/31/09'
'0','08/31/10'
'0','09/01/09'
'0','09/01/10'
'0','09/02/09'
'0','09/02/10'
'0','09/03/09'
'0','09/03/10'
'0','09/04/09'
'0','09/04/10'
'0','09/05/09'
'0','09/05/10'
'0','09/06/09'
'0','09/06/10'
'0','09/07/09'
'0','09/07/10'
'0','09/08/09'
'0','09/08/10'
'0','09/09/09'
'0','09/09/10'
'0','09/10/09'
'0','09/10/10'
'0','09/11/09'
'0','09/11/10'
'0','09/12/09'
'0','09/12/10'
'0','09/13/09'
'0','09/13/10'
'0','09/14/09'
'0','09/14/10'
'0','09/15/09'
'0','09/15/10'
'0','09/16/09'
'0','09/16/10'
'0','09/17/09'
'0','09/17/10'
'0','09/18/09'
'0','09/18/10'
'0','09/19/09'
'0','09/19/10'
'0','09/20/09'
'0','09/20/10'
'0','09/21/09'
'0','09/21/10'
'0','09/22/09'
'0','09/22/10'
'0','09/23/09'
'0','09/23/10'
'0','09/24/09'
'0','09/24/10'
'0','09/25/09'
'0','09/25/10'
'0','09/26/09'
'0','09/26/10'
'0','09/27/09'
'0','09/27/10'
'0','09/28/09'
'0','09/28/10'
'0','09/29/09'
'0','09/29/10'
'0','09/30/09'
'0','09/30/10'
'0','10/01/09'
'0','10/01/10'
'0','10/02/09'
'0','10/02/10'
'0','10/03/09'
'0','10/03/10'
'0','10/04/09'
'0','10/04/10'
'0','10/05/09'
'0','10/05/10'
'0','10/06/09'
'0','10/06/10'
'0','10/07/09'
'0','10/07/10'
'0','10/08/09'
'0','10/08/10'
'0','10/09/09'
'0','10/09/10'
'0','10/10/09'
'0','10/10/10'
'0','10/11/09'
'0','10/11/10'
'0','10/12/09'
'0','10/12/10'
'0','10/13/09'
'0','10/13/10'
'0','10/14/09'
'0','10/14/10'
'0','10/15/09'
'0','10/15/10'
'0','10/16/09'
'0','10/16/10'
'0','10/17/09'
'0','10/17/10'
'0','10/18/09'
'0','10/18/10'
'0','10/19/09'
'0','10/19/10'
'0','10/20/09'
'0','10/20/10'
'0','10/21/09'
'0','10/21/10'
'0','10/22/09'
'0','10/22/10'
'0','10/23/09'
'0','10/23/10'
'0','10/24/09'
'0','10/24/10'
'0','10/25/09'
'0','10/25/10'
'0','10/26/09'
'0','10/26/10'
'0','10/27/09'
'0','10/27/10'
'0','10/28/09'
'0','10/28/10'
'0','10/29/09'
'0','10/29/10'
'0','10/30/09'
'0','10/30/10'
'0','10/31/09'
'0','10/31/10'
'0','11/01/09'
'0','11/01/10'
'0','11/02/09'
'0','11/02/10'
'0','11/03/09'
'0','11/03/10'
'0','11/04/09'
'0','11/04/10'
'0','11/05/09'
'0','11/05/10'
'0','11/06/09'
'0','11/06/10'
'0','11/07/09'
'0','11/07/10'
'0','11/08/09'
'0','11/08/10'
'0','11/09/09'
'0','11/09/10'
'0','11/10/09'
'0','11/10/10'
'0','11/11/09'
'0','11/11/10'
'0','11/12/09'
'0','11/12/10'
'0','11/13/09'
'0','11/13/10'
'0','11/14/09'
'0','11/14/10'
'0','11/15/09'
'0','11/15/10'
'0','11/16/09'
'0','11/16/10'
'0','11/17/09'
'0','11/17/10'
'0','11/18/09'
'0','11/18/10'
'0','11/19/09'
'0','11/19/10'
'0','11/20/09'
'0','11/20/10'
'0','11/21/09'
'0','11/21/10'
'0','11/22/09'
'0','11/22/10'
'0','11/23/09'
'0','11/23/10'
'0','11/24/09'
'0','11/24/10'
'0','11/25/09'
'0','11/25/10'
'0','11/26/09'
'0','11/26/10'
'0','11/27/09'
'0','11/27/10'
'0','11/28/09'
'0','11/28/10'
'0','11/29/09'
'0','11/29/10'
'0','11/30/09'
'0','11/30/10'
'0','12/01/09'
'0','12/01/10'
'0','12/02/09'
'0','12/02/10'
'0','12/03/09'
'0','12/03/10'
'0','12/04/09'
'0','12/04/10'
'0','12/05/09'
'0','12/05/10'
'0','12/06/09'
'0','12/06/10'
'0','12/07/09'
'0','12/07/10'
'0','12/08/09'
'0','12/08/10'
'0','12/09/09'
'0','12/09/10'
'0','12/10/09'
'0','12/10/10'
'0','12/11/09'
'0','12/11/10'
'0','12/12/09'
'0','12/12/10'
'0','12/13/09'
'0','12/13/10'
'0','12/14/09'
'0','12/14/10'
'0','12/15/09'
'0','12/15/10'
'0','12/16/09'
'0','12/16/10'
'0','12/17/09'
'0','12/17/10'
'0','12/18/09'
'0','12/18/10'
'0','12/19/09'
'0','12/19/10'
'0','12/20/09'
'0','12/20/10'
'0','12/21/09'
'0','12/21/10'
'0','12/22/09'
'0','12/22/10'
'0','12/23/09'
'0','12/23/10'
'0','12/24/09'
'0','12/24/10'
'0','12/25/09'
'0','12/25/10'
'0','12/26/09'
'0','12/26/10'
'0','12/27/09'
'0','12/27/10'
'0','12/28/09'
'0','12/28/10'
'0','12/29/09'
'0','12/29/10'
'0','12/30/09'
'0','12/30/10'
'0','12/31/09'
'0','12/31/10'
'1','01/01/09'
'1','01/01/10'
'1','01/02/09'
'1','01/02/10'
'1','01/03/09'
'1','01/03/10'
'1','01/04/09'
'1','01/04/10'
'1','01/05/09'
'1','01/05/10'
'1','01/06/09'
'1','01/06/10'
'1','01/07/09'
'1','01/07/10'
'1','01/08/09'
'1','01/08/10'
'1','01/09/09'
'1','01/09/10'
'1','01/10/09'
'1','01/10/10'
'1','01/11/09'
'1','01/11/10'
'1','01/12/09'
'1','01/12/10'
'1','01/13/09'
'1','01/13/10'
'1','01/14/09'
'1','01/14/10'
'1','01/15/09'
'1','01/15/10'
'1','01/16/09'
'1','01/16/10'
'1','01/17/09'
'1','01/17/10'
'1','01/18/09'
'1','01/18/10'
'1','01/19/09'
'1','01/19/10'
'1','01/20/09'
'1','01/20/10'
'1','01/21/09'
'1','01/21/10'
'1','01/22/09'
'1','01/22/10'
'1','01/23/09'
'1','01/23/10'
'1','01/24/09'
'1','01/24/10'
'1','01/25/09'
'1','01/25/10'
'1','01/26/09'
'1','01/26/10'
'1','01/27/09'
'1','01/27/10'
'1','01/28/09'
'1','01/28/10'
'1','01/29/09'
'1','01/29/10'
'1','01/30/09'
'1','01/30/10'
'1','01/31/09'
'1','01/31/10'
'1','02/01/09'
'1','02/01/10'
'1','02/02/09'
'1','02/02/10'
'1','02/03/09'
'1','02/03/10'
'1','02/04/09'
'1','02/04/10'
'1','02/05/09'
'1','02/05/10'
'1','02/06/09'
'1','02/06/10'
'1','02/07/09'
'1','02/07/10'
'1','02/08/09'
'1','02/08/10'
'1','02/09/09'
'1','02/09/10'
'1','02/10/09'
'1','02/10/10'
'1','02/11/09'
'1','02/11/10'
'1','02/12/09'
'1','02/12/10'
'1','02/13/09'
'1','02/13/10'
'1','02/14/09'
'1','02/14/10'
'1','02/15/09'
'1','02/15/10'
'1','02/16/09'
'1','02/16/10'
'1','02/17/09'
'1','02/17/10'
'1','02/18/09'
'1','02/18/10'
'1','02/19/09'
'1','02/19/10'
'1','02/20/09'
'1','02/20/10'
'1','02/21/09'
'1','02/21/10'
'1','02/22/09'
'1','02/22/10'
'1','02/23/09'
'1','02/23/10'
'1','02/24/09'
'1','02/24/10'
'1','02/25/09'
'1','02/25/10'
'1','02/26/09'
'1','02/26/10'
'1','02/27/09'
'1','02/27/10'
'1','02/28/09'
'1','02/28/10'
'1','03/01/09'
'1','03/01/10'
'1','03/02/09'
'1','03/02/10'
'1','03/03/09'
'1','03/03/10'
'1','03/04/09'
'1','03/04/10'
'1','03/05/09'
'1','03/05/10'
'1','03/06/09'
'1','03/06/10'
'1','03/07/09'
'1','03/07/10'
'1','03/08/09'
'1','03/08/10'
'1','03/09/09'
'1','03/09/10'
'1','03/10/09'
'1','03/10/10'
'1','03/11/09'
'1','03/11/10'
'1','03/12/09'
'1','03/12/10'
'1','03/13/09'
'1','03/13/10'
'1','03/14/09'
'1','03/14/10'
'1','03/15/09'
'1','03/15/10'
'1','03/16/09'
'1','03/16/10'
'1','03/17/09'
'1','03/17/10'
'1','03/18/09'
'1','03/18/10'
'1','03/19/09'
'1','03/19/10'
'1','03/20/09'
'1','03/20/10'
'1','03/21/09'
'1','03/21/10'
'1','03/22/09'
'1','03/22/10'
'1','03/23/09'
'1','03/23/10'
'1','03/24/09'
'1','03/24/10'
'1','03/25/09'
'1','03/25/10'
'1','03/26/09'
'1','03/26/10'
'1','03/27/09'
'1','03/27/10'
'1','03/28/09'
'1','03/28/10'
'1','03/29/09'
'1','03/29/10'
'1','03/30/09'
'1','03/30/10'
'1','03/31/09'
'1','03/31/10'
'1','04/01/09'
'1','04/01/10'
'1','04/02/09'
'1','04/02/10'
'1','04/03/09'
'1','04/03/10'
'1','04/04/09'
'1','04/04/10'
'1','04/05/09'
'1','04/05/10'
'1','04/06/09'
'1','04/06/10'
'1','04/07/09'
'1','04/07/10'
'1','04/08/09'
'1','04/08/10'
'1','04/09/09'
'1','04/09/10'
'1','04/10/09'
'1','04/10/10'
'1','04/11/09'
'1','04/11/10'
'1','04/12/09'
'1','04/12/10'
'1','04/13/09'
'1','04/13/10'
'1','04/14/09'
'1','04/14/10'
'1','04/15/09'
'1','04/15/10'
'1','04/16/09'
'1','04/16/10'
'1','04/17/09'
'1','04/17/10'
'1','04/18/09'
'1','04/18/10'
'1','04/19/09'
'1','04/19/10'
'1','04/20/09'
'1','04/20/10'
'1','04/21/09'
'1','04/21/10'
'1','04/22/09'
'1','04/22/10'
'1','04/23/09'
'1','04/23/10'
'1','04/24/09'
'1','04/24/10'
'1','04/25/09'
'1','04/25/10'
'1','04/26/09'
'1','04/26/10'
'1','04/27/09'
'1','04/27/10'
'1','04/28/09'
'1','04/28/10'
'1','04/29/09'
'1','04/29/10'
'1','04/30/09'
'1','04/30/10'
'1','05/01/09'
'1','05/01/10'
'1','05/02/09'
'1','05/02/10'
'1','05/03/09'
'1','05/03/10'
'1','05/04/09'
'1','05/04/10'
'1','05/05/09'
'1','05/05/10'
'1','05/06/09'
'1','05/06/10'
'1','05/07/09'
'1','05/07/10'
'1','05/08/09'
'1','05/08/10'
'1','05/09/09'
'1','05/09/10'
'1','05/10/09'
'1','05/10/10'
'1','05/11/09'
'1','05/11/10'
'1','05/12/09'
'1','05/12/10'
'1','05/13/09'
'1','05/13/10'
'1','05/14/09'
'1','05/14/10'
'1','05/15/09'
'1','05/15/10'
---- TYPES
STRING, STRING
====
---- QUERY
# Order by a Static Length column Descending
select
bigint_col,
double_col
from
alltypes
order by
bigint_col,
double_col
desc
limit 1000
---- RESULTS
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
0,0
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
10,10.1
---- TYPES
BIGINT, DOUBLE
====
---- QUERY
# Pre sorted input
select
bigint_col,
date_string_col
from (
select
bigint_col,
date_string_col
from
alltypes
order by
bigint_col,
date_string_col
limit 1000000
) as i
order by
bigint_col,
date_string_col
limit 1000
---- RESULTS
0,'01/01/09'
0,'01/01/10'
0,'01/02/09'
0,'01/02/10'
0,'01/03/09'
0,'01/03/10'
0,'01/04/09'
0,'01/04/10'
0,'01/05/09'
0,'01/05/10'
0,'01/06/09'
0,'01/06/10'
0,'01/07/09'
0,'01/07/10'
0,'01/08/09'
0,'01/08/10'
0,'01/09/09'
0,'01/09/10'
0,'01/10/09'
0,'01/10/10'
0,'01/11/09'
0,'01/11/10'
0,'01/12/09'
0,'01/12/10'
0,'01/13/09'
0,'01/13/10'
0,'01/14/09'
0,'01/14/10'
0,'01/15/09'
0,'01/15/10'
0,'01/16/09'
0,'01/16/10'
0,'01/17/09'
0,'01/17/10'
0,'01/18/09'
0,'01/18/10'
0,'01/19/09'
0,'01/19/10'
0,'01/20/09'
0,'01/20/10'
0,'01/21/09'
0,'01/21/10'
0,'01/22/09'
0,'01/22/10'
0,'01/23/09'
0,'01/23/10'
0,'01/24/09'
0,'01/24/10'
0,'01/25/09'
0,'01/25/10'
0,'01/26/09'
0,'01/26/10'
0,'01/27/09'
0,'01/27/10'
0,'01/28/09'
0,'01/28/10'
0,'01/29/09'
0,'01/29/10'
0,'01/30/09'
0,'01/30/10'
0,'01/31/09'
0,'01/31/10'
0,'02/01/09'
0,'02/01/10'
0,'02/02/09'
0,'02/02/10'
0,'02/03/09'
0,'02/03/10'
0,'02/04/09'
0,'02/04/10'
0,'02/05/09'
0,'02/05/10'
0,'02/06/09'
0,'02/06/10'
0,'02/07/09'
0,'02/07/10'
0,'02/08/09'
0,'02/08/10'
0,'02/09/09'
0,'02/09/10'
0,'02/10/09'
0,'02/10/10'
0,'02/11/09'
0,'02/11/10'
0,'02/12/09'
0,'02/12/10'
0,'02/13/09'
0,'02/13/10'
0,'02/14/09'
0,'02/14/10'
0,'02/15/09'
0,'02/15/10'
0,'02/16/09'
0,'02/16/10'
0,'02/17/09'
0,'02/17/10'
0,'02/18/09'
0,'02/18/10'
0,'02/19/09'
0,'02/19/10'
0,'02/20/09'
0,'02/20/10'
0,'02/21/09'
0,'02/21/10'
0,'02/22/09'
0,'02/22/10'
0,'02/23/09'
0,'02/23/10'
0,'02/24/09'
0,'02/24/10'
0,'02/25/09'
0,'02/25/10'
0,'02/26/09'
0,'02/26/10'
0,'02/27/09'
0,'02/27/10'
0,'02/28/09'
0,'02/28/10'
0,'03/01/09'
0,'03/01/10'
0,'03/02/09'
0,'03/02/10'
0,'03/03/09'
0,'03/03/10'
0,'03/04/09'
0,'03/04/10'
0,'03/05/09'
0,'03/05/10'
0,'03/06/09'
0,'03/06/10'
0,'03/07/09'
0,'03/07/10'
0,'03/08/09'
0,'03/08/10'
0,'03/09/09'
0,'03/09/10'
0,'03/10/09'
0,'03/10/10'
0,'03/11/09'
0,'03/11/10'
0,'03/12/09'
0,'03/12/10'
0,'03/13/09'
0,'03/13/10'
0,'03/14/09'
0,'03/14/10'
0,'03/15/09'
0,'03/15/10'
0,'03/16/09'
0,'03/16/10'
0,'03/17/09'
0,'03/17/10'
0,'03/18/09'
0,'03/18/10'
0,'03/19/09'
0,'03/19/10'
0,'03/20/09'
0,'03/20/10'
0,'03/21/09'
0,'03/21/10'
0,'03/22/09'
0,'03/22/10'
0,'03/23/09'
0,'03/23/10'
0,'03/24/09'
0,'03/24/10'
0,'03/25/09'
0,'03/25/10'
0,'03/26/09'
0,'03/26/10'
0,'03/27/09'
0,'03/27/10'
0,'03/28/09'
0,'03/28/10'
0,'03/29/09'
0,'03/29/10'
0,'03/30/09'
0,'03/30/10'
0,'03/31/09'
0,'03/31/10'
0,'04/01/09'
0,'04/01/10'
0,'04/02/09'
0,'04/02/10'
0,'04/03/09'
0,'04/03/10'
0,'04/04/09'
0,'04/04/10'
0,'04/05/09'
0,'04/05/10'
0,'04/06/09'
0,'04/06/10'
0,'04/07/09'
0,'04/07/10'
0,'04/08/09'
0,'04/08/10'
0,'04/09/09'
0,'04/09/10'
0,'04/10/09'
0,'04/10/10'
0,'04/11/09'
0,'04/11/10'
0,'04/12/09'
0,'04/12/10'
0,'04/13/09'
0,'04/13/10'
0,'04/14/09'
0,'04/14/10'
0,'04/15/09'
0,'04/15/10'
0,'04/16/09'
0,'04/16/10'
0,'04/17/09'
0,'04/17/10'
0,'04/18/09'
0,'04/18/10'
0,'04/19/09'
0,'04/19/10'
0,'04/20/09'
0,'04/20/10'
0,'04/21/09'
0,'04/21/10'
0,'04/22/09'
0,'04/22/10'
0,'04/23/09'
0,'04/23/10'
0,'04/24/09'
0,'04/24/10'
0,'04/25/09'
0,'04/25/10'
0,'04/26/09'
0,'04/26/10'
0,'04/27/09'
0,'04/27/10'
0,'04/28/09'
0,'04/28/10'
0,'04/29/09'
0,'04/29/10'
0,'04/30/09'
0,'04/30/10'
0,'05/01/09'
0,'05/01/10'
0,'05/02/09'
0,'05/02/10'
0,'05/03/09'
0,'05/03/10'
0,'05/04/09'
0,'05/04/10'
0,'05/05/09'
0,'05/05/10'
0,'05/06/09'
0,'05/06/10'
0,'05/07/09'
0,'05/07/10'
0,'05/08/09'
0,'05/08/10'
0,'05/09/09'
0,'05/09/10'
0,'05/10/09'
0,'05/10/10'
0,'05/11/09'
0,'05/11/10'
0,'05/12/09'
0,'05/12/10'
0,'05/13/09'
0,'05/13/10'
0,'05/14/09'
0,'05/14/10'
0,'05/15/09'
0,'05/15/10'
0,'05/16/09'
0,'05/16/10'
0,'05/17/09'
0,'05/17/10'
0,'05/18/09'
0,'05/18/10'
0,'05/19/09'
0,'05/19/10'
0,'05/20/09'
0,'05/20/10'
0,'05/21/09'
0,'05/21/10'
0,'05/22/09'
0,'05/22/10'
0,'05/23/09'
0,'05/23/10'
0,'05/24/09'
0,'05/24/10'
0,'05/25/09'
0,'05/25/10'
0,'05/26/09'
0,'05/26/10'
0,'05/27/09'
0,'05/27/10'
0,'05/28/09'
0,'05/28/10'
0,'05/29/09'
0,'05/29/10'
0,'05/30/09'
0,'05/30/10'
0,'05/31/09'
0,'05/31/10'
0,'06/01/09'
0,'06/01/10'
0,'06/02/09'
0,'06/02/10'
0,'06/03/09'
0,'06/03/10'
0,'06/04/09'
0,'06/04/10'
0,'06/05/09'
0,'06/05/10'
0,'06/06/09'
0,'06/06/10'
0,'06/07/09'
0,'06/07/10'
0,'06/08/09'
0,'06/08/10'
0,'06/09/09'
0,'06/09/10'
0,'06/10/09'
0,'06/10/10'
0,'06/11/09'
0,'06/11/10'
0,'06/12/09'
0,'06/12/10'
0,'06/13/09'
0,'06/13/10'
0,'06/14/09'
0,'06/14/10'
0,'06/15/09'
0,'06/15/10'
0,'06/16/09'
0,'06/16/10'
0,'06/17/09'
0,'06/17/10'
0,'06/18/09'
0,'06/18/10'
0,'06/19/09'
0,'06/19/10'
0,'06/20/09'
0,'06/20/10'
0,'06/21/09'
0,'06/21/10'
0,'06/22/09'
0,'06/22/10'
0,'06/23/09'
0,'06/23/10'
0,'06/24/09'
0,'06/24/10'
0,'06/25/09'
0,'06/25/10'
0,'06/26/09'
0,'06/26/10'
0,'06/27/09'
0,'06/27/10'
0,'06/28/09'
0,'06/28/10'
0,'06/29/09'
0,'06/29/10'
0,'06/30/09'
0,'06/30/10'
0,'07/01/09'
0,'07/01/10'
0,'07/02/09'
0,'07/02/10'
0,'07/03/09'
0,'07/03/10'
0,'07/04/09'
0,'07/04/10'
0,'07/05/09'
0,'07/05/10'
0,'07/06/09'
0,'07/06/10'
0,'07/07/09'
0,'07/07/10'
0,'07/08/09'
0,'07/08/10'
0,'07/09/09'
0,'07/09/10'
0,'07/10/09'
0,'07/10/10'
0,'07/11/09'
0,'07/11/10'
0,'07/12/09'
0,'07/12/10'
0,'07/13/09'
0,'07/13/10'
0,'07/14/09'
0,'07/14/10'
0,'07/15/09'
0,'07/15/10'
0,'07/16/09'
0,'07/16/10'
0,'07/17/09'
0,'07/17/10'
0,'07/18/09'
0,'07/18/10'
0,'07/19/09'
0,'07/19/10'
0,'07/20/09'
0,'07/20/10'
0,'07/21/09'
0,'07/21/10'
0,'07/22/09'
0,'07/22/10'
0,'07/23/09'
0,'07/23/10'
0,'07/24/09'
0,'07/24/10'
0,'07/25/09'
0,'07/25/10'
0,'07/26/09'
0,'07/26/10'
0,'07/27/09'
0,'07/27/10'
0,'07/28/09'
0,'07/28/10'
0,'07/29/09'
0,'07/29/10'
0,'07/30/09'
0,'07/30/10'
0,'07/31/09'
0,'07/31/10'
0,'08/01/09'
0,'08/01/10'
0,'08/02/09'
0,'08/02/10'
0,'08/03/09'
0,'08/03/10'
0,'08/04/09'
0,'08/04/10'
0,'08/05/09'
0,'08/05/10'
0,'08/06/09'
0,'08/06/10'
0,'08/07/09'
0,'08/07/10'
0,'08/08/09'
0,'08/08/10'
0,'08/09/09'
0,'08/09/10'
0,'08/10/09'
0,'08/10/10'
0,'08/11/09'
0,'08/11/10'
0,'08/12/09'
0,'08/12/10'
0,'08/13/09'
0,'08/13/10'
0,'08/14/09'
0,'08/14/10'
0,'08/15/09'
0,'08/15/10'
0,'08/16/09'
0,'08/16/10'
0,'08/17/09'
0,'08/17/10'
0,'08/18/09'
0,'08/18/10'
0,'08/19/09'
0,'08/19/10'
0,'08/20/09'
0,'08/20/10'
0,'08/21/09'
0,'08/21/10'
0,'08/22/09'
0,'08/22/10'
0,'08/23/09'
0,'08/23/10'
0,'08/24/09'
0,'08/24/10'
0,'08/25/09'
0,'08/25/10'
0,'08/26/09'
0,'08/26/10'
0,'08/27/09'
0,'08/27/10'
0,'08/28/09'
0,'08/28/10'
0,'08/29/09'
0,'08/29/10'
0,'08/30/09'
0,'08/30/10'
0,'08/31/09'
0,'08/31/10'
0,'09/01/09'
0,'09/01/10'
0,'09/02/09'
0,'09/02/10'
0,'09/03/09'
0,'09/03/10'
0,'09/04/09'
0,'09/04/10'
0,'09/05/09'
0,'09/05/10'
0,'09/06/09'
0,'09/06/10'
0,'09/07/09'
0,'09/07/10'
0,'09/08/09'
0,'09/08/10'
0,'09/09/09'
0,'09/09/10'
0,'09/10/09'
0,'09/10/10'
0,'09/11/09'
0,'09/11/10'
0,'09/12/09'
0,'09/12/10'
0,'09/13/09'
0,'09/13/10'
0,'09/14/09'
0,'09/14/10'
0,'09/15/09'
0,'09/15/10'
0,'09/16/09'
0,'09/16/10'
0,'09/17/09'
0,'09/17/10'
0,'09/18/09'
0,'09/18/10'
0,'09/19/09'
0,'09/19/10'
0,'09/20/09'
0,'09/20/10'
0,'09/21/09'
0,'09/21/10'
0,'09/22/09'
0,'09/22/10'
0,'09/23/09'
0,'09/23/10'
0,'09/24/09'
0,'09/24/10'
0,'09/25/09'
0,'09/25/10'
0,'09/26/09'
0,'09/26/10'
0,'09/27/09'
0,'09/27/10'
0,'09/28/09'
0,'09/28/10'
0,'09/29/09'
0,'09/29/10'
0,'09/30/09'
0,'09/30/10'
0,'10/01/09'
0,'10/01/10'
0,'10/02/09'
0,'10/02/10'
0,'10/03/09'
0,'10/03/10'
0,'10/04/09'
0,'10/04/10'
0,'10/05/09'
0,'10/05/10'
0,'10/06/09'
0,'10/06/10'
0,'10/07/09'
0,'10/07/10'
0,'10/08/09'
0,'10/08/10'
0,'10/09/09'
0,'10/09/10'
0,'10/10/09'
0,'10/10/10'
0,'10/11/09'
0,'10/11/10'
0,'10/12/09'
0,'10/12/10'
0,'10/13/09'
0,'10/13/10'
0,'10/14/09'
0,'10/14/10'
0,'10/15/09'
0,'10/15/10'
0,'10/16/09'
0,'10/16/10'
0,'10/17/09'
0,'10/17/10'
0,'10/18/09'
0,'10/18/10'
0,'10/19/09'
0,'10/19/10'
0,'10/20/09'
0,'10/20/10'
0,'10/21/09'
0,'10/21/10'
0,'10/22/09'
0,'10/22/10'
0,'10/23/09'
0,'10/23/10'
0,'10/24/09'
0,'10/24/10'
0,'10/25/09'
0,'10/25/10'
0,'10/26/09'
0,'10/26/10'
0,'10/27/09'
0,'10/27/10'
0,'10/28/09'
0,'10/28/10'
0,'10/29/09'
0,'10/29/10'
0,'10/30/09'
0,'10/30/10'
0,'10/31/09'
0,'10/31/10'
0,'11/01/09'
0,'11/01/10'
0,'11/02/09'
0,'11/02/10'
0,'11/03/09'
0,'11/03/10'
0,'11/04/09'
0,'11/04/10'
0,'11/05/09'
0,'11/05/10'
0,'11/06/09'
0,'11/06/10'
0,'11/07/09'
0,'11/07/10'
0,'11/08/09'
0,'11/08/10'
0,'11/09/09'
0,'11/09/10'
0,'11/10/09'
0,'11/10/10'
0,'11/11/09'
0,'11/11/10'
0,'11/12/09'
0,'11/12/10'
0,'11/13/09'
0,'11/13/10'
0,'11/14/09'
0,'11/14/10'
0,'11/15/09'
0,'11/15/10'
0,'11/16/09'
0,'11/16/10'
0,'11/17/09'
0,'11/17/10'
0,'11/18/09'
0,'11/18/10'
0,'11/19/09'
0,'11/19/10'
0,'11/20/09'
0,'11/20/10'
0,'11/21/09'
0,'11/21/10'
0,'11/22/09'
0,'11/22/10'
0,'11/23/09'
0,'11/23/10'
0,'11/24/09'
0,'11/24/10'
0,'11/25/09'
0,'11/25/10'
0,'11/26/09'
0,'11/26/10'
0,'11/27/09'
0,'11/27/10'
0,'11/28/09'
0,'11/28/10'
0,'11/29/09'
0,'11/29/10'
0,'11/30/09'
0,'11/30/10'
0,'12/01/09'
0,'12/01/10'
0,'12/02/09'
0,'12/02/10'
0,'12/03/09'
0,'12/03/10'
0,'12/04/09'
0,'12/04/10'
0,'12/05/09'
0,'12/05/10'
0,'12/06/09'
0,'12/06/10'
0,'12/07/09'
0,'12/07/10'
0,'12/08/09'
0,'12/08/10'
0,'12/09/09'
0,'12/09/10'
0,'12/10/09'
0,'12/10/10'
0,'12/11/09'
0,'12/11/10'
0,'12/12/09'
0,'12/12/10'
0,'12/13/09'
0,'12/13/10'
0,'12/14/09'
0,'12/14/10'
0,'12/15/09'
0,'12/15/10'
0,'12/16/09'
0,'12/16/10'
0,'12/17/09'
0,'12/17/10'
0,'12/18/09'
0,'12/18/10'
0,'12/19/09'
0,'12/19/10'
0,'12/20/09'
0,'12/20/10'
0,'12/21/09'
0,'12/21/10'
0,'12/22/09'
0,'12/22/10'
0,'12/23/09'
0,'12/23/10'
0,'12/24/09'
0,'12/24/10'
0,'12/25/09'
0,'12/25/10'
0,'12/26/09'
0,'12/26/10'
0,'12/27/09'
0,'12/27/10'
0,'12/28/09'
0,'12/28/10'
0,'12/29/09'
0,'12/29/10'
0,'12/30/09'
0,'12/30/10'
0,'12/31/09'
0,'12/31/10'
10,'01/01/09'
10,'01/01/10'
10,'01/02/09'
10,'01/02/10'
10,'01/03/09'
10,'01/03/10'
10,'01/04/09'
10,'01/04/10'
10,'01/05/09'
10,'01/05/10'
10,'01/06/09'
10,'01/06/10'
10,'01/07/09'
10,'01/07/10'
10,'01/08/09'
10,'01/08/10'
10,'01/09/09'
10,'01/09/10'
10,'01/10/09'
10,'01/10/10'
10,'01/11/09'
10,'01/11/10'
10,'01/12/09'
10,'01/12/10'
10,'01/13/09'
10,'01/13/10'
10,'01/14/09'
10,'01/14/10'
10,'01/15/09'
10,'01/15/10'
10,'01/16/09'
10,'01/16/10'
10,'01/17/09'
10,'01/17/10'
10,'01/18/09'
10,'01/18/10'
10,'01/19/09'
10,'01/19/10'
10,'01/20/09'
10,'01/20/10'
10,'01/21/09'
10,'01/21/10'
10,'01/22/09'
10,'01/22/10'
10,'01/23/09'
10,'01/23/10'
10,'01/24/09'
10,'01/24/10'
10,'01/25/09'
10,'01/25/10'
10,'01/26/09'
10,'01/26/10'
10,'01/27/09'
10,'01/27/10'
10,'01/28/09'
10,'01/28/10'
10,'01/29/09'
10,'01/29/10'
10,'01/30/09'
10,'01/30/10'
10,'01/31/09'
10,'01/31/10'
10,'02/01/09'
10,'02/01/10'
10,'02/02/09'
10,'02/02/10'
10,'02/03/09'
10,'02/03/10'
10,'02/04/09'
10,'02/04/10'
10,'02/05/09'
10,'02/05/10'
10,'02/06/09'
10,'02/06/10'
10,'02/07/09'
10,'02/07/10'
10,'02/08/09'
10,'02/08/10'
10,'02/09/09'
10,'02/09/10'
10,'02/10/09'
10,'02/10/10'
10,'02/11/09'
10,'02/11/10'
10,'02/12/09'
10,'02/12/10'
10,'02/13/09'
10,'02/13/10'
10,'02/14/09'
10,'02/14/10'
10,'02/15/09'
10,'02/15/10'
10,'02/16/09'
10,'02/16/10'
10,'02/17/09'
10,'02/17/10'
10,'02/18/09'
10,'02/18/10'
10,'02/19/09'
10,'02/19/10'
10,'02/20/09'
10,'02/20/10'
10,'02/21/09'
10,'02/21/10'
10,'02/22/09'
10,'02/22/10'
10,'02/23/09'
10,'02/23/10'
10,'02/24/09'
10,'02/24/10'
10,'02/25/09'
10,'02/25/10'
10,'02/26/09'
10,'02/26/10'
10,'02/27/09'
10,'02/27/10'
10,'02/28/09'
10,'02/28/10'
10,'03/01/09'
10,'03/01/10'
10,'03/02/09'
10,'03/02/10'
10,'03/03/09'
10,'03/03/10'
10,'03/04/09'
10,'03/04/10'
10,'03/05/09'
10,'03/05/10'
10,'03/06/09'
10,'03/06/10'
10,'03/07/09'
10,'03/07/10'
10,'03/08/09'
10,'03/08/10'
10,'03/09/09'
10,'03/09/10'
10,'03/10/09'
10,'03/10/10'
10,'03/11/09'
10,'03/11/10'
10,'03/12/09'
10,'03/12/10'
10,'03/13/09'
10,'03/13/10'
10,'03/14/09'
10,'03/14/10'
10,'03/15/09'
10,'03/15/10'
10,'03/16/09'
10,'03/16/10'
10,'03/17/09'
10,'03/17/10'
10,'03/18/09'
10,'03/18/10'
10,'03/19/09'
10,'03/19/10'
10,'03/20/09'
10,'03/20/10'
10,'03/21/09'
10,'03/21/10'
10,'03/22/09'
10,'03/22/10'
10,'03/23/09'
10,'03/23/10'
10,'03/24/09'
10,'03/24/10'
10,'03/25/09'
10,'03/25/10'
10,'03/26/09'
10,'03/26/10'
10,'03/27/09'
10,'03/27/10'
10,'03/28/09'
10,'03/28/10'
10,'03/29/09'
10,'03/29/10'
10,'03/30/09'
10,'03/30/10'
10,'03/31/09'
10,'03/31/10'
10,'04/01/09'
10,'04/01/10'
10,'04/02/09'
10,'04/02/10'
10,'04/03/09'
10,'04/03/10'
10,'04/04/09'
10,'04/04/10'
10,'04/05/09'
10,'04/05/10'
10,'04/06/09'
10,'04/06/10'
10,'04/07/09'
10,'04/07/10'
10,'04/08/09'
10,'04/08/10'
10,'04/09/09'
10,'04/09/10'
10,'04/10/09'
10,'04/10/10'
10,'04/11/09'
10,'04/11/10'
10,'04/12/09'
10,'04/12/10'
10,'04/13/09'
10,'04/13/10'
10,'04/14/09'
10,'04/14/10'
10,'04/15/09'
10,'04/15/10'
10,'04/16/09'
10,'04/16/10'
10,'04/17/09'
10,'04/17/10'
10,'04/18/09'
10,'04/18/10'
10,'04/19/09'
10,'04/19/10'
10,'04/20/09'
10,'04/20/10'
10,'04/21/09'
10,'04/21/10'
10,'04/22/09'
10,'04/22/10'
10,'04/23/09'
10,'04/23/10'
10,'04/24/09'
10,'04/24/10'
10,'04/25/09'
10,'04/25/10'
10,'04/26/09'
10,'04/26/10'
10,'04/27/09'
10,'04/27/10'
10,'04/28/09'
10,'04/28/10'
10,'04/29/09'
10,'04/29/10'
10,'04/30/09'
10,'04/30/10'
10,'05/01/09'
10,'05/01/10'
10,'05/02/09'
10,'05/02/10'
10,'05/03/09'
10,'05/03/10'
10,'05/04/09'
10,'05/04/10'
10,'05/05/09'
10,'05/05/10'
10,'05/06/09'
10,'05/06/10'
10,'05/07/09'
10,'05/07/10'
10,'05/08/09'
10,'05/08/10'
10,'05/09/09'
10,'05/09/10'
10,'05/10/09'
10,'05/10/10'
10,'05/11/09'
10,'05/11/10'
10,'05/12/09'
10,'05/12/10'
10,'05/13/09'
10,'05/13/10'
10,'05/14/09'
10,'05/14/10'
10,'05/15/09'
10,'05/15/10'
---- TYPES
BIGINT, STRING
====
---- QUERY
# Pre sorted in reverse input
select
bigint_col,
date_string_col
from (
select
bigint_col,
date_string_col
from
alltypes
order by
bigint_col,
date_string_col
desc
limit 1000000
) as i
order by
bigint_col,
date_string_col
limit 1000
---- RESULTS
0,'01/01/09'
0,'01/01/10'
0,'01/02/09'
0,'01/02/10'
0,'01/03/09'
0,'01/03/10'
0,'01/04/09'
0,'01/04/10'
0,'01/05/09'
0,'01/05/10'
0,'01/06/09'
0,'01/06/10'
0,'01/07/09'
0,'01/07/10'
0,'01/08/09'
0,'01/08/10'
0,'01/09/09'
0,'01/09/10'
0,'01/10/09'
0,'01/10/10'
0,'01/11/09'
0,'01/11/10'
0,'01/12/09'
0,'01/12/10'
0,'01/13/09'
0,'01/13/10'
0,'01/14/09'
0,'01/14/10'
0,'01/15/09'
0,'01/15/10'
0,'01/16/09'
0,'01/16/10'
0,'01/17/09'
0,'01/17/10'
0,'01/18/09'
0,'01/18/10'
0,'01/19/09'
0,'01/19/10'
0,'01/20/09'
0,'01/20/10'
0,'01/21/09'
0,'01/21/10'
0,'01/22/09'
0,'01/22/10'
0,'01/23/09'
0,'01/23/10'
0,'01/24/09'
0,'01/24/10'
0,'01/25/09'
0,'01/25/10'
0,'01/26/09'
0,'01/26/10'
0,'01/27/09'
0,'01/27/10'
0,'01/28/09'
0,'01/28/10'
0,'01/29/09'
0,'01/29/10'
0,'01/30/09'
0,'01/30/10'
0,'01/31/09'
0,'01/31/10'
0,'02/01/09'
0,'02/01/10'
0,'02/02/09'
0,'02/02/10'
0,'02/03/09'
0,'02/03/10'
0,'02/04/09'
0,'02/04/10'
0,'02/05/09'
0,'02/05/10'
0,'02/06/09'
0,'02/06/10'
0,'02/07/09'
0,'02/07/10'
0,'02/08/09'
0,'02/08/10'
0,'02/09/09'
0,'02/09/10'
0,'02/10/09'
0,'02/10/10'
0,'02/11/09'
0,'02/11/10'
0,'02/12/09'
0,'02/12/10'
0,'02/13/09'
0,'02/13/10'
0,'02/14/09'
0,'02/14/10'
0,'02/15/09'
0,'02/15/10'
0,'02/16/09'
0,'02/16/10'
0,'02/17/09'
0,'02/17/10'
0,'02/18/09'
0,'02/18/10'
0,'02/19/09'
0,'02/19/10'
0,'02/20/09'
0,'02/20/10'
0,'02/21/09'
0,'02/21/10'
0,'02/22/09'
0,'02/22/10'
0,'02/23/09'
0,'02/23/10'
0,'02/24/09'
0,'02/24/10'
0,'02/25/09'
0,'02/25/10'
0,'02/26/09'
0,'02/26/10'
0,'02/27/09'
0,'02/27/10'
0,'02/28/09'
0,'02/28/10'
0,'03/01/09'
0,'03/01/10'
0,'03/02/09'
0,'03/02/10'
0,'03/03/09'
0,'03/03/10'
0,'03/04/09'
0,'03/04/10'
0,'03/05/09'
0,'03/05/10'
0,'03/06/09'
0,'03/06/10'
0,'03/07/09'
0,'03/07/10'
0,'03/08/09'
0,'03/08/10'
0,'03/09/09'
0,'03/09/10'
0,'03/10/09'
0,'03/10/10'
0,'03/11/09'
0,'03/11/10'
0,'03/12/09'
0,'03/12/10'
0,'03/13/09'
0,'03/13/10'
0,'03/14/09'
0,'03/14/10'
0,'03/15/09'
0,'03/15/10'
0,'03/16/09'
0,'03/16/10'
0,'03/17/09'
0,'03/17/10'
0,'03/18/09'
0,'03/18/10'
0,'03/19/09'
0,'03/19/10'
0,'03/20/09'
0,'03/20/10'
0,'03/21/09'
0,'03/21/10'
0,'03/22/09'
0,'03/22/10'
0,'03/23/09'
0,'03/23/10'
0,'03/24/09'
0,'03/24/10'
0,'03/25/09'
0,'03/25/10'
0,'03/26/09'
0,'03/26/10'
0,'03/27/09'
0,'03/27/10'
0,'03/28/09'
0,'03/28/10'
0,'03/29/09'
0,'03/29/10'
0,'03/30/09'
0,'03/30/10'
0,'03/31/09'
0,'03/31/10'
0,'04/01/09'
0,'04/01/10'
0,'04/02/09'
0,'04/02/10'
0,'04/03/09'
0,'04/03/10'
0,'04/04/09'
0,'04/04/10'
0,'04/05/09'
0,'04/05/10'
0,'04/06/09'
0,'04/06/10'
0,'04/07/09'
0,'04/07/10'
0,'04/08/09'
0,'04/08/10'
0,'04/09/09'
0,'04/09/10'
0,'04/10/09'
0,'04/10/10'
0,'04/11/09'
0,'04/11/10'
0,'04/12/09'
0,'04/12/10'
0,'04/13/09'
0,'04/13/10'
0,'04/14/09'
0,'04/14/10'
0,'04/15/09'
0,'04/15/10'
0,'04/16/09'
0,'04/16/10'
0,'04/17/09'
0,'04/17/10'
0,'04/18/09'
0,'04/18/10'
0,'04/19/09'
0,'04/19/10'
0,'04/20/09'
0,'04/20/10'
0,'04/21/09'
0,'04/21/10'
0,'04/22/09'
0,'04/22/10'
0,'04/23/09'
0,'04/23/10'
0,'04/24/09'
0,'04/24/10'
0,'04/25/09'
0,'04/25/10'
0,'04/26/09'
0,'04/26/10'
0,'04/27/09'
0,'04/27/10'
0,'04/28/09'
0,'04/28/10'
0,'04/29/09'
0,'04/29/10'
0,'04/30/09'
0,'04/30/10'
0,'05/01/09'
0,'05/01/10'
0,'05/02/09'
0,'05/02/10'
0,'05/03/09'
0,'05/03/10'
0,'05/04/09'
0,'05/04/10'
0,'05/05/09'
0,'05/05/10'
0,'05/06/09'
0,'05/06/10'
0,'05/07/09'
0,'05/07/10'
0,'05/08/09'
0,'05/08/10'
0,'05/09/09'
0,'05/09/10'
0,'05/10/09'
0,'05/10/10'
0,'05/11/09'
0,'05/11/10'
0,'05/12/09'
0,'05/12/10'
0,'05/13/09'
0,'05/13/10'
0,'05/14/09'
0,'05/14/10'
0,'05/15/09'
0,'05/15/10'
0,'05/16/09'
0,'05/16/10'
0,'05/17/09'
0,'05/17/10'
0,'05/18/09'
0,'05/18/10'
0,'05/19/09'
0,'05/19/10'
0,'05/20/09'
0,'05/20/10'
0,'05/21/09'
0,'05/21/10'
0,'05/22/09'
0,'05/22/10'
0,'05/23/09'
0,'05/23/10'
0,'05/24/09'
0,'05/24/10'
0,'05/25/09'
0,'05/25/10'
0,'05/26/09'
0,'05/26/10'
0,'05/27/09'
0,'05/27/10'
0,'05/28/09'
0,'05/28/10'
0,'05/29/09'
0,'05/29/10'
0,'05/30/09'
0,'05/30/10'
0,'05/31/09'
0,'05/31/10'
0,'06/01/09'
0,'06/01/10'
0,'06/02/09'
0,'06/02/10'
0,'06/03/09'
0,'06/03/10'
0,'06/04/09'
0,'06/04/10'
0,'06/05/09'
0,'06/05/10'
0,'06/06/09'
0,'06/06/10'
0,'06/07/09'
0,'06/07/10'
0,'06/08/09'
0,'06/08/10'
0,'06/09/09'
0,'06/09/10'
0,'06/10/09'
0,'06/10/10'
0,'06/11/09'
0,'06/11/10'
0,'06/12/09'
0,'06/12/10'
0,'06/13/09'
0,'06/13/10'
0,'06/14/09'
0,'06/14/10'
0,'06/15/09'
0,'06/15/10'
0,'06/16/09'
0,'06/16/10'
0,'06/17/09'
0,'06/17/10'
0,'06/18/09'
0,'06/18/10'
0,'06/19/09'
0,'06/19/10'
0,'06/20/09'
0,'06/20/10'
0,'06/21/09'
0,'06/21/10'
0,'06/22/09'
0,'06/22/10'
0,'06/23/09'
0,'06/23/10'
0,'06/24/09'
0,'06/24/10'
0,'06/25/09'
0,'06/25/10'
0,'06/26/09'
0,'06/26/10'
0,'06/27/09'
0,'06/27/10'
0,'06/28/09'
0,'06/28/10'
0,'06/29/09'
0,'06/29/10'
0,'06/30/09'
0,'06/30/10'
0,'07/01/09'
0,'07/01/10'
0,'07/02/09'
0,'07/02/10'
0,'07/03/09'
0,'07/03/10'
0,'07/04/09'
0,'07/04/10'
0,'07/05/09'
0,'07/05/10'
0,'07/06/09'
0,'07/06/10'
0,'07/07/09'
0,'07/07/10'
0,'07/08/09'
0,'07/08/10'
0,'07/09/09'
0,'07/09/10'
0,'07/10/09'
0,'07/10/10'
0,'07/11/09'
0,'07/11/10'
0,'07/12/09'
0,'07/12/10'
0,'07/13/09'
0,'07/13/10'
0,'07/14/09'
0,'07/14/10'
0,'07/15/09'
0,'07/15/10'
0,'07/16/09'
0,'07/16/10'
0,'07/17/09'
0,'07/17/10'
0,'07/18/09'
0,'07/18/10'
0,'07/19/09'
0,'07/19/10'
0,'07/20/09'
0,'07/20/10'
0,'07/21/09'
0,'07/21/10'
0,'07/22/09'
0,'07/22/10'
0,'07/23/09'
0,'07/23/10'
0,'07/24/09'
0,'07/24/10'
0,'07/25/09'
0,'07/25/10'
0,'07/26/09'
0,'07/26/10'
0,'07/27/09'
0,'07/27/10'
0,'07/28/09'
0,'07/28/10'
0,'07/29/09'
0,'07/29/10'
0,'07/30/09'
0,'07/30/10'
0,'07/31/09'
0,'07/31/10'
0,'08/01/09'
0,'08/01/10'
0,'08/02/09'
0,'08/02/10'
0,'08/03/09'
0,'08/03/10'
0,'08/04/09'
0,'08/04/10'
0,'08/05/09'
0,'08/05/10'
0,'08/06/09'
0,'08/06/10'
0,'08/07/09'
0,'08/07/10'
0,'08/08/09'
0,'08/08/10'
0,'08/09/09'
0,'08/09/10'
0,'08/10/09'
0,'08/10/10'
0,'08/11/09'
0,'08/11/10'
0,'08/12/09'
0,'08/12/10'
0,'08/13/09'
0,'08/13/10'
0,'08/14/09'
0,'08/14/10'
0,'08/15/09'
0,'08/15/10'
0,'08/16/09'
0,'08/16/10'
0,'08/17/09'
0,'08/17/10'
0,'08/18/09'
0,'08/18/10'
0,'08/19/09'
0,'08/19/10'
0,'08/20/09'
0,'08/20/10'
0,'08/21/09'
0,'08/21/10'
0,'08/22/09'
0,'08/22/10'
0,'08/23/09'
0,'08/23/10'
0,'08/24/09'
0,'08/24/10'
0,'08/25/09'
0,'08/25/10'
0,'08/26/09'
0,'08/26/10'
0,'08/27/09'
0,'08/27/10'
0,'08/28/09'
0,'08/28/10'
0,'08/29/09'
0,'08/29/10'
0,'08/30/09'
0,'08/30/10'
0,'08/31/09'
0,'08/31/10'
0,'09/01/09'
0,'09/01/10'
0,'09/02/09'
0,'09/02/10'
0,'09/03/09'
0,'09/03/10'
0,'09/04/09'
0,'09/04/10'
0,'09/05/09'
0,'09/05/10'
0,'09/06/09'
0,'09/06/10'
0,'09/07/09'
0,'09/07/10'
0,'09/08/09'
0,'09/08/10'
0,'09/09/09'
0,'09/09/10'
0,'09/10/09'
0,'09/10/10'
0,'09/11/09'
0,'09/11/10'
0,'09/12/09'
0,'09/12/10'
0,'09/13/09'
0,'09/13/10'
0,'09/14/09'
0,'09/14/10'
0,'09/15/09'
0,'09/15/10'
0,'09/16/09'
0,'09/16/10'
0,'09/17/09'
0,'09/17/10'
0,'09/18/09'
0,'09/18/10'
0,'09/19/09'
0,'09/19/10'
0,'09/20/09'
0,'09/20/10'
0,'09/21/09'
0,'09/21/10'
0,'09/22/09'
0,'09/22/10'
0,'09/23/09'
0,'09/23/10'
0,'09/24/09'
0,'09/24/10'
0,'09/25/09'
0,'09/25/10'
0,'09/26/09'
0,'09/26/10'
0,'09/27/09'
0,'09/27/10'
0,'09/28/09'
0,'09/28/10'
0,'09/29/09'
0,'09/29/10'
0,'09/30/09'
0,'09/30/10'
0,'10/01/09'
0,'10/01/10'
0,'10/02/09'
0,'10/02/10'
0,'10/03/09'
0,'10/03/10'
0,'10/04/09'
0,'10/04/10'
0,'10/05/09'
0,'10/05/10'
0,'10/06/09'
0,'10/06/10'
0,'10/07/09'
0,'10/07/10'
0,'10/08/09'
0,'10/08/10'
0,'10/09/09'
0,'10/09/10'
0,'10/10/09'
0,'10/10/10'
0,'10/11/09'
0,'10/11/10'
0,'10/12/09'
0,'10/12/10'
0,'10/13/09'
0,'10/13/10'
0,'10/14/09'
0,'10/14/10'
0,'10/15/09'
0,'10/15/10'
0,'10/16/09'
0,'10/16/10'
0,'10/17/09'
0,'10/17/10'
0,'10/18/09'
0,'10/18/10'
0,'10/19/09'
0,'10/19/10'
0,'10/20/09'
0,'10/20/10'
0,'10/21/09'
0,'10/21/10'
0,'10/22/09'
0,'10/22/10'
0,'10/23/09'
0,'10/23/10'
0,'10/24/09'
0,'10/24/10'
0,'10/25/09'
0,'10/25/10'
0,'10/26/09'
0,'10/26/10'
0,'10/27/09'
0,'10/27/10'
0,'10/28/09'
0,'10/28/10'
0,'10/29/09'
0,'10/29/10'
0,'10/30/09'
0,'10/30/10'
0,'10/31/09'
0,'10/31/10'
0,'11/01/09'
0,'11/01/10'
0,'11/02/09'
0,'11/02/10'
0,'11/03/09'
0,'11/03/10'
0,'11/04/09'
0,'11/04/10'
0,'11/05/09'
0,'11/05/10'
0,'11/06/09'
0,'11/06/10'
0,'11/07/09'
0,'11/07/10'
0,'11/08/09'
0,'11/08/10'
0,'11/09/09'
0,'11/09/10'
0,'11/10/09'
0,'11/10/10'
0,'11/11/09'
0,'11/11/10'
0,'11/12/09'
0,'11/12/10'
0,'11/13/09'
0,'11/13/10'
0,'11/14/09'
0,'11/14/10'
0,'11/15/09'
0,'11/15/10'
0,'11/16/09'
0,'11/16/10'
0,'11/17/09'
0,'11/17/10'
0,'11/18/09'
0,'11/18/10'
0,'11/19/09'
0,'11/19/10'
0,'11/20/09'
0,'11/20/10'
0,'11/21/09'
0,'11/21/10'
0,'11/22/09'
0,'11/22/10'
0,'11/23/09'
0,'11/23/10'
0,'11/24/09'
0,'11/24/10'
0,'11/25/09'
0,'11/25/10'
0,'11/26/09'
0,'11/26/10'
0,'11/27/09'
0,'11/27/10'
0,'11/28/09'
0,'11/28/10'
0,'11/29/09'
0,'11/29/10'
0,'11/30/09'
0,'11/30/10'
0,'12/01/09'
0,'12/01/10'
0,'12/02/09'
0,'12/02/10'
0,'12/03/09'
0,'12/03/10'
0,'12/04/09'
0,'12/04/10'
0,'12/05/09'
0,'12/05/10'
0,'12/06/09'
0,'12/06/10'
0,'12/07/09'
0,'12/07/10'
0,'12/08/09'
0,'12/08/10'
0,'12/09/09'
0,'12/09/10'
0,'12/10/09'
0,'12/10/10'
0,'12/11/09'
0,'12/11/10'
0,'12/12/09'
0,'12/12/10'
0,'12/13/09'
0,'12/13/10'
0,'12/14/09'
0,'12/14/10'
0,'12/15/09'
0,'12/15/10'
0,'12/16/09'
0,'12/16/10'
0,'12/17/09'
0,'12/17/10'
0,'12/18/09'
0,'12/18/10'
0,'12/19/09'
0,'12/19/10'
0,'12/20/09'
0,'12/20/10'
0,'12/21/09'
0,'12/21/10'
0,'12/22/09'
0,'12/22/10'
0,'12/23/09'
0,'12/23/10'
0,'12/24/09'
0,'12/24/10'
0,'12/25/09'
0,'12/25/10'
0,'12/26/09'
0,'12/26/10'
0,'12/27/09'
0,'12/27/10'
0,'12/28/09'
0,'12/28/10'
0,'12/29/09'
0,'12/29/10'
0,'12/30/09'
0,'12/30/10'
0,'12/31/09'
0,'12/31/10'
10,'01/01/09'
10,'01/01/10'
10,'01/02/09'
10,'01/02/10'
10,'01/03/09'
10,'01/03/10'
10,'01/04/09'
10,'01/04/10'
10,'01/05/09'
10,'01/05/10'
10,'01/06/09'
10,'01/06/10'
10,'01/07/09'
10,'01/07/10'
10,'01/08/09'
10,'01/08/10'
10,'01/09/09'
10,'01/09/10'
10,'01/10/09'
10,'01/10/10'
10,'01/11/09'
10,'01/11/10'
10,'01/12/09'
10,'01/12/10'
10,'01/13/09'
10,'01/13/10'
10,'01/14/09'
10,'01/14/10'
10,'01/15/09'
10,'01/15/10'
10,'01/16/09'
10,'01/16/10'
10,'01/17/09'
10,'01/17/10'
10,'01/18/09'
10,'01/18/10'
10,'01/19/09'
10,'01/19/10'
10,'01/20/09'
10,'01/20/10'
10,'01/21/09'
10,'01/21/10'
10,'01/22/09'
10,'01/22/10'
10,'01/23/09'
10,'01/23/10'
10,'01/24/09'
10,'01/24/10'
10,'01/25/09'
10,'01/25/10'
10,'01/26/09'
10,'01/26/10'
10,'01/27/09'
10,'01/27/10'
10,'01/28/09'
10,'01/28/10'
10,'01/29/09'
10,'01/29/10'
10,'01/30/09'
10,'01/30/10'
10,'01/31/09'
10,'01/31/10'
10,'02/01/09'
10,'02/01/10'
10,'02/02/09'
10,'02/02/10'
10,'02/03/09'
10,'02/03/10'
10,'02/04/09'
10,'02/04/10'
10,'02/05/09'
10,'02/05/10'
10,'02/06/09'
10,'02/06/10'
10,'02/07/09'
10,'02/07/10'
10,'02/08/09'
10,'02/08/10'
10,'02/09/09'
10,'02/09/10'
10,'02/10/09'
10,'02/10/10'
10,'02/11/09'
10,'02/11/10'
10,'02/12/09'
10,'02/12/10'
10,'02/13/09'
10,'02/13/10'
10,'02/14/09'
10,'02/14/10'
10,'02/15/09'
10,'02/15/10'
10,'02/16/09'
10,'02/16/10'
10,'02/17/09'
10,'02/17/10'
10,'02/18/09'
10,'02/18/10'
10,'02/19/09'
10,'02/19/10'
10,'02/20/09'
10,'02/20/10'
10,'02/21/09'
10,'02/21/10'
10,'02/22/09'
10,'02/22/10'
10,'02/23/09'
10,'02/23/10'
10,'02/24/09'
10,'02/24/10'
10,'02/25/09'
10,'02/25/10'
10,'02/26/09'
10,'02/26/10'
10,'02/27/09'
10,'02/27/10'
10,'02/28/09'
10,'02/28/10'
10,'03/01/09'
10,'03/01/10'
10,'03/02/09'
10,'03/02/10'
10,'03/03/09'
10,'03/03/10'
10,'03/04/09'
10,'03/04/10'
10,'03/05/09'
10,'03/05/10'
10,'03/06/09'
10,'03/06/10'
10,'03/07/09'
10,'03/07/10'
10,'03/08/09'
10,'03/08/10'
10,'03/09/09'
10,'03/09/10'
10,'03/10/09'
10,'03/10/10'
10,'03/11/09'
10,'03/11/10'
10,'03/12/09'
10,'03/12/10'
10,'03/13/09'
10,'03/13/10'
10,'03/14/09'
10,'03/14/10'
10,'03/15/09'
10,'03/15/10'
10,'03/16/09'
10,'03/16/10'
10,'03/17/09'
10,'03/17/10'
10,'03/18/09'
10,'03/18/10'
10,'03/19/09'
10,'03/19/10'
10,'03/20/09'
10,'03/20/10'
10,'03/21/09'
10,'03/21/10'
10,'03/22/09'
10,'03/22/10'
10,'03/23/09'
10,'03/23/10'
10,'03/24/09'
10,'03/24/10'
10,'03/25/09'
10,'03/25/10'
10,'03/26/09'
10,'03/26/10'
10,'03/27/09'
10,'03/27/10'
10,'03/28/09'
10,'03/28/10'
10,'03/29/09'
10,'03/29/10'
10,'03/30/09'
10,'03/30/10'
10,'03/31/09'
10,'03/31/10'
10,'04/01/09'
10,'04/01/10'
10,'04/02/09'
10,'04/02/10'
10,'04/03/09'
10,'04/03/10'
10,'04/04/09'
10,'04/04/10'
10,'04/05/09'
10,'04/05/10'
10,'04/06/09'
10,'04/06/10'
10,'04/07/09'
10,'04/07/10'
10,'04/08/09'
10,'04/08/10'
10,'04/09/09'
10,'04/09/10'
10,'04/10/09'
10,'04/10/10'
10,'04/11/09'
10,'04/11/10'
10,'04/12/09'
10,'04/12/10'
10,'04/13/09'
10,'04/13/10'
10,'04/14/09'
10,'04/14/10'
10,'04/15/09'
10,'04/15/10'
10,'04/16/09'
10,'04/16/10'
10,'04/17/09'
10,'04/17/10'
10,'04/18/09'
10,'04/18/10'
10,'04/19/09'
10,'04/19/10'
10,'04/20/09'
10,'04/20/10'
10,'04/21/09'
10,'04/21/10'
10,'04/22/09'
10,'04/22/10'
10,'04/23/09'
10,'04/23/10'
10,'04/24/09'
10,'04/24/10'
10,'04/25/09'
10,'04/25/10'
10,'04/26/09'
10,'04/26/10'
10,'04/27/09'
10,'04/27/10'
10,'04/28/09'
10,'04/28/10'
10,'04/29/09'
10,'04/29/10'
10,'04/30/09'
10,'04/30/10'
10,'05/01/09'
10,'05/01/10'
10,'05/02/09'
10,'05/02/10'
10,'05/03/09'
10,'05/03/10'
10,'05/04/09'
10,'05/04/10'
10,'05/05/09'
10,'05/05/10'
10,'05/06/09'
10,'05/06/10'
10,'05/07/09'
10,'05/07/10'
10,'05/08/09'
10,'05/08/10'
10,'05/09/09'
10,'05/09/10'
10,'05/10/09'
10,'05/10/10'
10,'05/11/09'
10,'05/11/10'
10,'05/12/09'
10,'05/12/10'
10,'05/13/09'
10,'05/13/10'
10,'05/14/09'
10,'05/14/10'
10,'05/15/09'
10,'05/15/10'
---- TYPES
BIGINT, STRING
====
---- QUERY
# Empty Input
select *
from
alltypes
where
bigint_col < -100
order by
string_col
---- RESULTS
---- TYPES
INT, BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, STRING, STRING, TIMESTAMP, INT, INT
====
---- QUERY
# Regression test for IMPALA-1148.
select 1 from functional.alltypestiny order by 1
---- RESULTS
1
1
1
1
1
1
1
1
---- TYPES
TINYINT
====
---- QUERY
# Test for corner case: fixed length data but only NULL var-len slots.
select id, cast(NULL as string) str
from functional.alltypestiny
order by 2, 1
---- RESULTS
0,'NULL'
1,'NULL'
2,'NULL'
3,'NULL'
4,'NULL'
5,'NULL'
6,'NULL'
7,'NULL'
---- TYPES
INT, STRING
====
---- QUERY
# Test for corner case: fixed length data but only zero-length var len data.
select id, ''
from functional.alltypestiny
order by 2 desc, 1 desc
---- RESULTS
7,''
6,''
5,''
4,''
3,''
2,''
1,''
0,''
---- TYPES
INT, STRING
====