@@ -68,13 +68,13 @@ class HBaseSQLQuerySuite extends TestBaseWithSplitData {
68
68
test(" SPARK-3176 Added Parser of SQL ABS()" ) {
69
69
checkAnswer(
70
70
sql(" SELECT ABS(-1.3)" ),
71
- Row (1.3 ))
71
+ Row (BigDecimal ( 1.3 ) ))
72
72
checkAnswer(
73
73
sql(" SELECT ABS(0.0)" ),
74
- Row (0.0 ))
74
+ Row (BigDecimal ( 0.0 ) ))
75
75
checkAnswer(
76
76
sql(" SELECT ABS(2.5)" ),
77
- Row (2.5 ))
77
+ Row (BigDecimal ( 2.5 ) ))
78
78
}
79
79
80
80
test(" aggregation with codegen" ) {
@@ -579,31 +579,31 @@ class HBaseSQLQuerySuite extends TestBaseWithSplitData {
579
579
val nonexistentKey = " nonexistent"
580
580
581
581
// "set" itself returns all config variables currently specified in SQLConf.
582
- assert(sql(" SET" ).collect().length == 0 )
582
+ assert(sql(" SET" ).collect().size == 0 )
583
583
584
584
// "set key=val"
585
585
sql(s " SET $testKey= $testVal" )
586
586
checkAnswer(
587
587
sql(" SET" ),
588
- Row (s " $ testKey= $ testVal" )
588
+ Row (testKey, testVal)
589
589
)
590
590
591
591
sql(s " SET ${testKey + testKey}= ${testVal + testVal}" )
592
592
checkAnswer(
593
593
sql(" set" ),
594
594
Seq (
595
- Row (s " $ testKey= $ testVal" ),
596
- Row (s " ${ testKey + testKey} = ${ testVal + testVal} " ))
595
+ Row (testKey, testVal),
596
+ Row (testKey + testKey, testVal + testVal))
597
597
)
598
598
599
599
// "set key"
600
600
checkAnswer(
601
601
sql(s " SET $testKey" ),
602
- Row (s " $ testKey= $ testVal" )
602
+ Row (testKey, testVal)
603
603
)
604
604
checkAnswer(
605
605
sql(s " SET $nonexistentKey" ),
606
- Row (s " $ nonexistentKey= <undefined>" )
606
+ Row (nonexistentKey, " <undefined>" )
607
607
)
608
608
conf.clear()
609
609
}
@@ -790,19 +790,19 @@ class HBaseSQLQuerySuite extends TestBaseWithSplitData {
790
790
791
791
test(" Floating point number format" ) {
792
792
checkAnswer(
793
- sql(" SELECT 0.3" ), Row (0.3 )
793
+ sql(" SELECT 0.3" ), Row (BigDecimal ( 0.3 ) )
794
794
)
795
795
796
796
checkAnswer(
797
- sql(" SELECT -0.8" ), Row (- 0.8 )
797
+ sql(" SELECT -0.8" ), Row (BigDecimal ( - 0.8 ) )
798
798
)
799
799
800
800
checkAnswer(
801
- sql(" SELECT .5" ), Row (0.5 )
801
+ sql(" SELECT .5" ), Row (BigDecimal ( 0.5 ) )
802
802
)
803
803
804
804
checkAnswer(
805
- sql(" SELECT -.18" ), Row (- 0.18 )
805
+ sql(" SELECT -.18" ), Row (BigDecimal ( - 0.18 ) )
806
806
)
807
807
}
808
808
@@ -827,19 +827,19 @@ class HBaseSQLQuerySuite extends TestBaseWithSplitData {
827
827
test(" Test to check we can apply sign to expression" ) {
828
828
829
829
checkAnswer(
830
- sql(" SELECT -100" ), Row (- 100 )
830
+ sql(" SELECT -100" ), Row (BigDecimal ( - 100 ) )
831
831
)
832
832
833
833
checkAnswer(
834
- sql(" SELECT +230" ), Row (230 )
834
+ sql(" SELECT +230" ), Row (BigDecimal ( 230 ) )
835
835
)
836
836
837
837
checkAnswer(
838
- sql(" SELECT -5.2" ), Row (- 5.2 )
838
+ sql(" SELECT -5.2" ), Row (BigDecimal ( - 5.2 ) )
839
839
)
840
840
841
841
checkAnswer(
842
- sql(" SELECT +6.8" ), Row (6.8 )
842
+ sql(" SELECT +6.8" ), Row (BigDecimal ( 6.8 ) )
843
843
)
844
844
845
845
checkAnswer(
0 commit comments