drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5608) cannot create view with an explicit cast to SMALLINT
Date Sun, 25 Jun 2017 14:00:00 GMT
N Campbell created DRILL-5608:
---------------------------------

             Summary: cannot create view with an explicit cast to SMALLINT
                 Key: DRILL-5608
                 URL: https://issues.apache.org/jira/browse/DRILL-5608
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10 JDBC and server

            Reporter: N Campbell


The APACHE drill JDBC driver does not return any table metadata (getTables etc) for a dfs
workspace. In order to allow a BI client to see metadata (getTables and getColumns) VIEWS
have to be defined. Attempting to create a view with an explicit type cast (which Drill requires)
will fail

create or replace view  TSINT as select cast(RNUM as int) RNUM ,  cast(CSINT as smallint)
CSINT from dfs.cert_data.tsint

Error: UNSUPPORTED_OPERATION ERROR: SMALLINT is not supported
See Apache Drill JIRA: DRILL-1959



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message