JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » 其他 Database  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to postflat modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 Apache drill 使上用的問題
benny139





發文: 198
積分: 2
於 2018-08-10 01:18 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
請高手們賜教
Apache-Drill 1.13
Database: sql server
JAR: sqljdbc41-4.2.6420.100.jar
0: jdbc:drill:zk=192.168.11.191> use crm.UTK_CRM;
+-------+------------------------------------------+
| ok | summary |
+-------+------------------------------------------+
| true | Default schema changed to [crm.UTK_CRM] |
+-------+------------------------------------------+
1 row selected (0.125 seconds)

0: jdbc:drill:zk=192.168.11.191> show tables;
+---------------+---------------------------------+
| TABLE_SCHEMA | TABLE_NAME |
+---------------+---------------------------------+
.......
| crm.UTK_CRM | hitachi_trans |
.......
+---------------+---------------------------------+

0: jdbc:drill:zk=192.168.11.191> desc crm.UTK_CRM.`hitachi_trans`;
+-----------------------+--------------------+--------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+-----------------------+--------------------+--------------+
| uriage_no | CHARACTER VARYING | NO |
| partition_no | CHARACTER VARYING | YES |
| kmt3g_id | CHARACTER VARYING | YES |
| kmt2g_id | CHARACTER VARYING | YES |
| kmtg_id | CHARACTER VARYING | YES |
| kmt_id | CHARACTER VARYING | YES |
| kaiin_no | CHARACTER VARYING | YES |
| tuka_id | CHARACTER VARYING | YES |
| pt_kakutoku_nendo | CHARACTER VARYING | YES |
| kaiin_hash_ti | CHARACTER VARYING | YES |
| torihiki_kbn | CHARACTER VARYING | YES |
| term_no | CHARACTER VARYING | YES |
| denpyo_no | CHARACTER VARYING | YES |
| torihiki_bi | CHARACTER VARYING | YES |
| torihiki_time | CHARACTER VARYING | YES |
| torihiki_kingaku | CHARACTER VARYING | YES |
| fuyo_pt | CHARACTER VARYING | YES |
| riyo_pt | CHARACTER VARYING | YES |
| tujo_fuyo_pt | CHARACTER VARYING | YES |
| kikan_fuyo_pt | CHARACTER VARYING | YES |
| tujo_riyo_pt | CHARACTER VARYING | YES |
| kikan_riyo_pt | CHARACTER VARYING | YES |
| jiyu_cd | CHARACTER VARYING | YES |
| jiyu_det_cd | CHARACTER VARYING | YES |
| fuyo_riyu | CHARACTER VARYING | YES |
| pt_kbn | CHARACTER VARYING | YES |
| kikan_pt_kaisi_bi | CHARACTER VARYING | YES |
| kikan_pt_syuryo_bi | CHARACTER VARYING | YES |
| daihyo_uriage_no | CHARACTER VARYING | YES |
| taisyo_uriage_no | CHARACTER VARYING | YES |
| biko1 | CHARACTER VARYING | YES |
| biko2 | CHARACTER VARYING | YES |
| biko3 | CHARACTER VARYING | YES |
| made_nitiji | CHARACTER VARYING | YES |
| made_usr | CHARACTER VARYING | YES |
| hash_ti | CHARACTER VARYING | YES |
| Do_Promotions_Data_2 | BOOLEAN | YES |
| RECON_DATE | CHARACTER VARYING | YES |
| Do_Promotions_Data_1 | BOOLEAN | YES |
| Do_Promotions_Data_3 | BOOLEAN | YES |
+-----------------------+--------------------+--------------+
40 rows selected (0.667 seconds)

select `hitachi_trans`.kmt_id
from crm.UTK_CRM.`hitachi_trans`
0: jdbc:drill:zk=192.168.11.191> select `hitachi_trans`.kmt_id
. . . . . . . . . . . . . . . .> from crm.UTK_CRM.`hitachi_trans`;
Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

sql SELECT "kmt_id"
FROM "UTK_CRM"."hitachi_trans"
plugin crm
Fragment 0:0

[Error Id: d867782f-d7d9-4dbe-ba9c-8836ca7ff4ec on hadoop-gw:31010]

(com.microsoft.sqlserver.jdbc.SQLServerException) 無效的物件名稱 'UTK_CRM.hitachi_trans'。
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError():217
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult():1635
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement():865
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute():762
com.microsoft.sqlserver.jdbc.TDSCommand.execute():6276
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand():1793
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand():184
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement():159
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery():661
org.apache.commons.dbcp.DelegatingStatement.executeQuery():208
org.apache.commons.dbcp.DelegatingStatement.executeQuery():208
org.apache.drill.exec.store.jdbc.JdbcRecordReader.setup():170
org.apache.drill.exec.physical.impl.ScanBatch.getNextReaderIfHas():245
org.apache.drill.exec.physical.impl.ScanBatch.next():164
org.apache.drill.exec.record.AbstractRecordBatch.next():119
org.apache.drill.exec.record.AbstractRecordBatch.next():109
org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134
org.apache.drill.exec.record.AbstractRecordBatch.next():164
org.apache.drill.exec.physical.impl.BaseRootExec.next():105
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():83
org.apache.drill.exec.physical.impl.BaseRootExec.next():95
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():233
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226
java.security.AccessController.doPrivileged():-2
javax.security.auth.Subject.doAs():422
org.apache.hadoop.security.UserGroupInformation.doAs():1657
org.apache.drill.exec.work.fragment.FragmentExecutor.run():226
org.apache.drill.common.SelfCleaningRunnable.run():38
java.util.concurrent.ThreadPoolExecutor.runWorker():1149
java.util.concurrent.ThreadPoolExecutor$Worker.run():624
java.lang.Thread.run():748 (state=,code=0)


reply to postreply to post
話題樹型展開
人氣 標題 作者 字數 發文時間
167 Apache drill 使上用的問題 benny139 5286 2018-08-10 01:18
» JWorld@TW »  JDBC/SQL討論區 » 其他 Database

reply to postflat modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8