[
https://issues.apache.org/jira/browse/DRILL-1098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14050501#comment-14050501
]
Rahul Challapalli commented on DRILL-1098:
------------------------------------------
Server error:
java.lang.AssertionError: typeName.allowsPrecScale(true, false)
org.eigenbase.sql.type.BasicSqlType.<init>(BasicSqlType.java:66)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.type.SqlTypeFactoryImpl.createSqlType(SqlTypeFactoryImpl.java:59)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.type.SqlTypeTransforms$4.transformType(SqlTypeTransforms.java:107)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:62)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:451)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:418)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:290)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:206)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3870)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:1)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlCall.accept(SqlCall.java:133)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1322)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1305)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:418)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3019)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2773)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:209)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:710)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426)
~[optiq-core-0.7-20140617.012959-7.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:175)
~[optiq-core-0.7-20140617.012959-7.jar:na]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:128)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:113)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:400)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:216)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:242)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> Trim function in Drill should default to 'space' when no trim characters are
> provided like Oracle and Postgres
> --------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-1098
> URL: https://issues.apache.org/jira/browse/DRILL-1098
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Rahul Challapalli
> Assignee: Mehant Baid
> Priority: Blocker
>
> git.commit.id.abbrev=a1a6144
> Build # 26266
> Any query where we use trim function without mentioning a 'trim character'
> fails
> select trim(pageURL) from rankings;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
