* 아래와 같은 에러 발생 시

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
08:38:00.352 [main] ERROR o.a.c.f.imps.CuratorFrameworkImpl - Background exception was not retry-able or retry gave up
java.net.UnknownHostException:  secondary: Temporary failure in name resolution
        at java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) ~[na:1.8.0_144]
        at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) ~[na:1.8.0_144]
        at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1323) ~[na:1.8.0_144]
        at java.net.InetAddress.getAllByName0(InetAddress.java:1276) ~[na:1.8.0_144]
        at java.net.InetAddress.getAllByName(InetAddress.java:1192) ~[na:1.8.0_144]
        at java.net.InetAddress.getAllByName(InetAddress.java:1126) ~[na:1.8.0_144]
        at org.apache.zookeeper.client.StaticHostProvider.<init>(StaticHostProvider.java:61) ~[zookeeper-3.4.6.jar:3.4.6-1569965]
        at org.apache.zookeeper.ZooKeeper.<init>(ZooKeeper.java:445) ~[zookeeper-3.4.6.jar:3.4.6-1569965]
        at org.apache.curator.utils.DefaultZookeeperFactory.newZooKeeper(DefaultZookeeperFactory.java:29) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.framework.imps.CuratorFrameworkImpl$2.newZooKeeper(CuratorFrameworkImpl.java:146) ~[curator-framework-2.7.1.jar:na]
        at org.apache.curator.HandleHolder$1.getZooKeeper(HandleHolder.java:94) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.HandleHolder.getZooKeeper(HandleHolder.java:55) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.ConnectionState.reset(ConnectionState.java:218) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.ConnectionState.start(ConnectionState.java:102) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.CuratorZookeeperClient.start(CuratorZookeeperClient.java:189) ~[curator-client-2.7.1.jar:na]
        at org.apache.curator.framework.imps.CuratorFrameworkImpl.start(CuratorFrameworkImpl.java:248) ~[curator-framework-2.7.1.jar:na]
        at org.apache.drill.exec.coord.zk.ZKClusterCoordinator.<init>(ZKClusterCoordinator.java:106) [drill-java-exec-1.11.0.jar:1.11.0]
        at org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:326) [drill-java-exec-1.11.0.jar:1.11.0]
        at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:158) [drill-jdbc-1.11.0.jar:1.11.0]
        at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72) [drill-jdbc-1.11.0.jar:1.11.0]
        at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) [drill-jdbc-1.11.0.jar:1.11.0]
        at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143) [calcite-avatica-1.4.0-drill-r21.jar:1.4.0-drill-r21]
        at org.apache.drill.jdbc.Driver.connect(Driver.java:72) [drill-jdbc-1.11.0.jar:1.11.0]
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.Commands.connect(Commands.java:1083) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.Commands.connect(Commands.java:1015) [sqlline-1.1.9-drill-r7.jar:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_144]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_144]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_144]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
        at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.SqlLine.dispatch(SqlLine.java:742) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.SqlLine.initArgs(SqlLine.java:528) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.SqlLine.begin(SqlLine.java:596) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.SqlLine.start(SqlLine.java:375) [sqlline-1.1.9-drill-r7.jar:na]
        at sqlline.SqlLine.main(SqlLine.java:268) [sqlline-1.1.9-drill-r7.jar:na]
Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client. (state=,code=0)
java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client.
        at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:167)
        at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
        at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
        at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
        at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
        at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
        at sqlline.Commands.connect(Commands.java:1083)
        at sqlline.Commands.connect(Commands.java:1015)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:742)
        at sqlline.SqlLine.initArgs(SqlLine.java:528)
        at sqlline.SqlLine.begin(SqlLine.java:596)
        at sqlline.SqlLine.start(SqlLine.java:375)
        at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client.
        at org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:329)
        at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:158)
        ... 18 more
Caused by: java.io.IOException: Failure to connect to the zookeeper cluster service within the allotted time of 10000 milliseconds.
        at org.apache.drill.exec.coord.zk.ZKClusterCoordinator.start(ZKClusterCoordinator.java:123)
        at org.apache.drill.exec.client.DrillClient.connect(DrillClient.java:327)
        ... 19 more
apache drill 1.11.0
"a drill in the hand is better than two in the bush"
0: jdbc:drill:>
                        
cs



* 발생 원인

 -> 클러스터링된 해당 서버들의 호스트명을 찾지 못 해서 발생된 에러입니다.



* 조치 사항

 -> 설정 파일의 호스트명 및 포트 번호가 적절하게 기재되어 있는지를 확인합니다.

 -> zookeeper 및 drill 서버가 기동 상태인지 확인을 합니다.



저작자표시

'Big Data Platform > Drill' 카테고리의 다른 글

[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION  (0) 2017.10.18
[에러] Java 1.7 or later is required to run Apache Drill  (0) 2017.10.17
Drill 환경 구축 (분산 모드)  (0) 2017.10.10


* 아래와 같은 에러 발생 시

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
$ /usr/local/drill/bin/drill-localhost
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Error: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : java.net.ConnectException: Connection refused: localhost/127.0.0.1:31010 (state=,code=0)
java.sql.SQLException: Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION : java.net.ConnectException: Connection refused: localhost/127.0.0.1:31010
        at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:167)
        at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
        at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69)
        at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:143)
        at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
        at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
        at sqlline.Commands.connect(Commands.java:1083)
        at sqlline.Commands.connect(Commands.java:1015)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
        at sqlline.SqlLine.dispatch(SqlLine.java:742)
        at sqlline.SqlLine.initArgs(SqlLine.java:528)
        at sqlline.SqlLine.begin(SqlLine.java:596)
        at sqlline.SqlLine.start(SqlLine.java:375)
        at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.exec.rpc.RpcException: CONNECTION : java.net.ConnectException: Connection refused: localhost/127.0.0.1:31010
        at org.apache.drill.exec.rpc.user.UserClient$2.connectionFailed(UserClient.java:197)
        at org.apache.drill.exec.rpc.user.QueryResultHandler$ChannelClosedHandler.connectionFailed(QueryResultHandler.java:389)
        at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:249)
        at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:212)
        at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)
        at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)
        at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)
        at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)
        at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:268)
        at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:284)
        at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:528)
        at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
        at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
        at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.util.concurrent.ExecutionException: java.net.ConnectException: Connection refused: localhost/127.0.0.1:31010
        at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:47)
        at org.apache.drill.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:225)
        ... 13 more
Caused by: java.net.ConnectException: Connection refused: localhost/127.0.0.1:31010
        at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
        at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:717)
        at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:224)
        at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:281)
        ... 6 more
apache drill 1.11.0
"the only truly happy people are children, the creative minority and drill users"
0: jdbc:drill:drillbit=localhost>
 
cs



* 발생 원인

 -> 클러스터링된 해당 서버와 연결에 실패해서 발생된 에러입니다.



* 조치 사항

 -> 각 서버와 통신에 이상 없는지를 확인합니다.

 -> drill-override.conf 파일을 확인합니다.

  ㄴ 참고 사항

1
2
3
4
5
drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "test1:2181, test2:2181, test3:2181, test4:2181, test5:2181"
}
 
cs

* 위와 같이 각 서버의 호스트명과 포트 번호를 콤마로 구분해서 기입할 때 띄어쓰기를 할 경우 인식하지 못 하므로 주의하세요!



저작자표시

'Big Data Platform > Drill' 카테고리의 다른 글

[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client  (0) 2017.10.18
[에러] Java 1.7 or later is required to run Apache Drill  (0) 2017.10.17
Drill 환경 구축 (분산 모드)  (0) 2017.10.10


* 아래와 같은 알림 발생 시

1
2
3
$ /usr/local/drill/bin/drillbit.sh
ERROR: Java 1.7 or later is required to run Apache Drill.
 
cs

 -> 드릴을 실행하기 위해서 자바 버전이 1.7 혹은 그 이후의 버전이 요구된다는 알림입니다.


* 조치 사항

 : 원인은 크게 2가지로 볼 수 있습니다.

 -> 자바 버전이 1.7 이후의 버전이 아닐 경우

  ㄴ 자바 버전을 상위 버전으로 재설치합니다.


 -> 자바 버전이 1.7 이후의 버전이지만 체크를 하지 못한 경우

  ㄴ 버전이 1.7 이후인 경우에는 아래의 과정을 진행합니다.



1. /bin/drill-config.sh 파일을 편집

1
2
$ vi /usr/local/apache-drill-1.11.0/bin/drill-config.sh
 
cs



2. 아래에 해당하는 부분을 검색

1
2
3
4
5
6
# Ensure that Java version is at least 1.7
"$JAVA" -version 2>&1 | grep "version" | egrep -e "1.4|1.5|1.6" > /dev/null
if [ $? -eq 0 ]; then
  fatal_error "Java 1.7 or later is required to run Apache Drill."
fi
 
cs

* 자바 버전을 체크하는 부분입니다.

* 정규 표현식 "1.4" 는 자바 버전의 업데이트 번호 144와 일치합니다. 따라서 부동 소수점은 "1\.4" 로 이스케이프 돼야 합니다.



3. 해당 부분을 치환

1
2
3
4
5
6
# Ensure that Java version is at least 1.7
"$JAVA" -version 2>&1 | grep "version" | egrep -e "1\.4|1.5|1.6" > /dev/null
if [ $? -eq 0 ]; then
  fatal_error "Java 1.7 or later is required to run Apache Drill."
fi
 
cs

* 위와 같이 치환하고 저장 후 종료합니다. 그리고 다시 drill daemon 을 실행합니다.



저작자표시

'Big Data Platform > Drill' 카테고리의 다른 글

[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client  (0) 2017.10.18
[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION  (0) 2017.10.18
Drill 환경 구축 (분산 모드)  (0) 2017.10.10


버전: 1.11.0

* 사전 요구 사항 *

 ㄴ 해당 작업을 진행하기 이전에 jdk 설치가 되어 있어야 합니다.

  ㄴ Drill 1.6 이후의 버전은 jdk version 7 or 8

 ㄴ Zookeeper Service 실행

 ㄴ Hadoop cluster

 ㄴ DNS 사용


1. drill 을 다운로드합니다.

1
2
3
4
5
6
7
8
9
10
11
12
$ wget http://apache.mirror.cdnetworks.com/drill/drill-1.11.0/apache-drill-1.11.0.tar.gz
--2017-10-10 16:17:59--  http://apache.mirror.cdnetworks.com/drill/drill-1.11.0/apache-drill-1.11.0.tar.gz
Resolving apache.mirror.cdnetworks.com (apache.mirror.cdnetworks.com)... 14.0.101.165
Connecting to apache.mirror.cdnetworks.com (apache.mirror.cdnetworks.com)|14.0.101.165|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 198337695 (189M) [application/x-gzip]
Saving to: ‘apache-drill-1.11.0.tar.gz’
 
apache-drill-1.11.0 100%[===================>] 189.15M  10.4MB/s    in 19s
 
2017-10-10 16:18:17 (10.2 MB/s) - ‘apache-drill-1.11.0.tar.gz’ saved [198337695/198337695]
 
cs



2. 다운로드 받은 파일을 확인합니다.

1
2
3
$ ls ./apache-drill-1.11.0.tar.gz
./apache-drill-1.11.0.tar.gz
 
cs



3. 확인 후에 압축을 실행합니다.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
$ tar -xvzf apache-drill-1.11.0.tar.gz
apache-drill-1.11.0/jars/jdbc-driver/drill-jdbc-all-1.11.0.jar
apache-drill-1.11.0/jars/classb/reflections-0.9.8.jar
apache-drill-1.11.0/jars/classb/codemodel-2.6.jar
apache-drill-1.11.0/jars/classb/javax.servlet-api-3.1.0.jar
apache-drill-1.11.0/jars/classb/jersey-container-jetty-servlet-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-container-servlet-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-container-servlet-core-2.8.jar
apache-drill-1.11.0/jars/classb/javax.inject-2.2.0.jar
apache-drill-1.11.0/jars/classb/jersey-server-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-common-2.8.jar
apache-drill-1.11.0/jars/classb/javax.ws.rs-api-2.0.jar
apache-drill-1.11.0/jars/classb/javax.annotation-api-1.2.jar
apache-drill-1.11.0/jars/classb/jersey-guava-2.8.jar
apache-drill-1.11.0/jars/classb/hk2-api-2.2.0.jar
apache-drill-1.11.0/jars/classb/hk2-utils-2.2.0.jar
apache-drill-1.11.0/jars/classb/aopalliance-repackaged-2.2.0.jar
apache-drill-1.11.0/jars/classb/hk2-locator-2.2.0.jar
apache-drill-1.11.0/jars/classb/osgi-resource-locator-1.0.1.jar
apache-drill-1.11.0/jars/classb/jersey-client-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-container-jetty-http-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-media-multipart-2.8.jar
apache-drill-1.11.0/jars/classb/mimepull-1.9.3.jar
apache-drill-1.11.0/jars/classb/jersey-mvc-freemarker-2.8.jar
apache-drill-1.11.0/jars/classb/jersey-mvc-2.8.jar
apache-drill-1.11.0/jars/classb/jetty-util-6.1.26.jar
apache-drill-1.11.0/jars/classb/jetty-6.1.26.jar
apache-drill-1.11.0/jars/classb/jaxb-api-2.2.2.jar
apache-drill-1.11.0/jars/classb/activation-1.1.jar
apache-drill-1.11.0/jars/classb/logback-classic-1.0.13.jar
apache-drill-1.11.0/jars/classb/logback-core-1.0.13.jar
apache-drill-1.11.0/jars/drill-protocol-1.11.0.jar
apache-drill-1.11.0/jars/drill-logical-1.11.0.jar
apache-drill-1.11.0/jars/drill-common-1.11.0.jar
apache-drill-1.11.0/jars/vector-1.11.0.jar
apache-drill-1.11.0/jars/drill-memory-base-1.11.0.jar
apache-drill-1.11.0/jars/drill-rpc-1.11.0.jar
apache-drill-1.11.0/jars/drill-java-exec-1.11.0.jar
apache-drill-1.11.0/jars/drill-jdbc-1.11.0.jar
apache-drill-1.11.0/jars/tpch-sample-data-1.11.0.jar
apache-drill-1.11.0/jars/drill-kudu-storage-1.11.0.jar
apache-drill-1.11.0/jars/drill-mongo-storage-1.11.0.jar
apache-drill-1.11.0/jars/drill-storage-hbase-1.11.0.jar
apache-drill-1.11.0/jars/drill-jdbc-storage-1.11.0.jar
apache-drill-1.11.0/jars/drill-storage-hive-core-1.11.0.jar
apache-drill-1.11.0/jars/drill-hive-exec-shaded-1.11.0.jar
apache-drill-1.11.0/jars/drill-gis-1.11.0.jar
apache-drill-1.11.0/jars/3rdparty/protobuf-java-2.5.0.jar
apache-drill-1.11.0/jars/3rdparty/protostuff-core-1.0.8.jar
apache-drill-1.11.0/jars/3rdparty/protostuff-api-1.0.8.jar
apache-drill-1.11.0/jars/3rdparty/protostuff-json-1.0.8.jar
apache-drill-1.11.0/jars/3rdparty/jackson-core-asl-1.9.13.jar
apache-drill-1.11.0/jars/3rdparty/netty-handler-4.0.27.Final.jar
apache-drill-1.11.0/jars/3rdparty/netty-buffer-4.0.27.Final.jar
apache-drill-1.11.0/jars/3rdparty/netty-common-4.0.27.Final.jar
apache-drill-1.11.0/jars/3rdparty/netty-transport-4.0.27.Final.jar
apache-drill-1.11.0/jars/3rdparty/netty-codec-4.0.27.Final.jar
apache-drill-1.11.0/jars/3rdparty/guava-18.0.jar
apache-drill-1.11.0/jars/3rdparty/slf4j-api-1.7.6.jar
apache-drill-1.11.0/jars/3rdparty/jul-to-slf4j-1.7.6.jar
apache-drill-1.11.0/jars/3rdparty/jcl-over-slf4j-1.7.6.jar
apache-drill-1.11.0/jars/3rdparty/log4j-over-slf4j-1.7.6.jar
apache-drill-1.11.0/jars/3rdparty/commons-io-2.4.jar
apache-drill-1.11.0/jars/3rdparty/mockito-core-1.9.5.jar
apache-drill-1.11.0/jars/3rdparty/hamcrest-core-1.1.jar
apache-drill-1.11.0/jars/3rdparty/objenesis-1.0.jar
apache-drill-1.11.0/jars/3rdparty/snappy-java-1.1.2.6.jar
apache-drill-1.11.0/jars/3rdparty/calcite-core-1.4.0-drill-r21.jar
apache-drill-1.11.0/jars/3rdparty/calcite-avatica-1.4.0-drill-r21.jar
apache-drill-1.11.0/jars/3rdparty/calcite-linq4j-1.4.0-drill-r21.jar
apache-drill-1.11.0/jars/3rdparty/commons-dbcp-1.4.jar
apache-drill-1.11.0/jars/3rdparty/commons-pool-1.5.4.jar
apache-drill-1.11.0/jars/3rdparty/jsr305-3.0.0.jar
apache-drill-1.11.0/jars/3rdparty/eigenbase-properties-1.1.5.jar
apache-drill-1.11.0/jars/3rdparty/janino-2.7.6.jar
apache-drill-1.11.0/jars/3rdparty/commons-compiler-2.7.6.jar
apache-drill-1.11.0/jars/3rdparty/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
apache-drill-1.11.0/jars/3rdparty/commons-lang-2.6.jar
apache-drill-1.11.0/jars/3rdparty/config-1.0.0.jar
apache-drill-1.11.0/jars/3rdparty/commons-lang3-3.1.jar
apache-drill-1.11.0/jars/3rdparty/msgpack-0.6.6.jar
apache-drill-1.11.0/jars/3rdparty/json-simple-1.1.1.jar
apache-drill-1.11.0/jars/3rdparty/javassist-3.16.1-GA.jar
apache-drill-1.11.0/jars/3rdparty/javassist-3.12.1.GA.jar
apache-drill-1.11.0/jars/3rdparty/dom4j-1.6.1.jar
apache-drill-1.11.0/jars/3rdparty/xml-apis-1.4.01.jar
apache-drill-1.11.0/jars/3rdparty/jackson-annotations-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jackson-databind-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jackson-core-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/metrics-core-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/metrics-servlets-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/metrics-healthchecks-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/metrics-json-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/metrics-jvm-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/antlr-runtime-3.4.jar
apache-drill-1.11.0/jars/3rdparty/stringtemplate-3.2.1.jar
apache-drill-1.11.0/jars/3rdparty/antlr-2.7.7.jar
apache-drill-1.11.0/jars/3rdparty/joda-time-2.9.jar
apache-drill-1.11.0/jars/3rdparty/hppc-0.7.1.jar
apache-drill-1.11.0/jars/3rdparty/netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar
apache-drill-1.11.0/jars/3rdparty/asm-debug-all-5.0.3.jar
apache-drill-1.11.0/jars/3rdparty/commons-pool2-2.1.jar
apache-drill-1.11.0/jars/3rdparty/univocity-parsers-1.3.0.jar
apache-drill-1.11.0/jars/3rdparty/commons-math-2.2.jar
apache-drill-1.11.0/jars/3rdparty/commons-codec-1.10.jar
apache-drill-1.11.0/jars/3rdparty/paranamer-2.5.6.jar
apache-drill-1.11.0/jars/3rdparty/xercesImpl-2.11.0.jar
apache-drill-1.11.0/jars/3rdparty/xalan-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/serializer-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jetty-server-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-http-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-util-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-io-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-servlet-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-security-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/jetty-servlets-9.1.5.v20140505.jar
apache-drill-1.11.0/jars/3rdparty/validation-api-1.1.0.Final.jar
apache-drill-1.11.0/jars/3rdparty/jetty-continuation-9.1.1.v20140108.jar
apache-drill-1.11.0/jars/3rdparty/jetty-webapp-9.1.1.v20140108.jar
apache-drill-1.11.0/jars/3rdparty/jetty-xml-9.1.1.v20140108.jar
apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-json-provider-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-base-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jackson-module-jaxb-annotations-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/mongo-java-driver-3.2.0.jar
apache-drill-1.11.0/jars/3rdparty/jackson-module-afterburner-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/freemarker-2.3.21.jar
apache-drill-1.11.0/jars/3rdparty/jpam-1.1.jar
apache-drill-1.11.0/jars/3rdparty/bcpkix-jdk15on-1.52.jar
apache-drill-1.11.0/jars/3rdparty/bcprov-jdk15on-1.52.jar
apache-drill-1.11.0/jars/3rdparty/parquet-column-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/parquet-common-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/parquet-encoding-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/parquet-hadoop-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/parquet-format-2.3.0-incubating.jar
apache-drill-1.11.0/jars/3rdparty/parquet-jackson-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/jackson-mapper-asl-1.9.11.jar
apache-drill-1.11.0/jars/3rdparty/parquet-generator-1.8.1-drill-r0.jar
apache-drill-1.11.0/jars/3rdparty/javax.inject-1.jar
apache-drill-1.11.0/jars/3rdparty/jcommander-1.30.jar
apache-drill-1.11.0/jars/3rdparty/curator-x-discovery-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/curator-recipes-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/curator-framework-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/curator-client-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jline-2.10.jar
apache-drill-1.11.0/jars/3rdparty/netty-3.7.0.Final.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-common-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-annotations-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/jdk.tools-1.7.jar
apache-drill-1.11.0/jars/3rdparty/commons-cli-1.2.jar
apache-drill-1.11.0/jars/3rdparty/commons-math3-3.1.1.jar
apache-drill-1.11.0/jars/3rdparty/xmlenc-0.52.jar
apache-drill-1.11.0/jars/3rdparty/commons-httpclient-3.1.jar
apache-drill-1.11.0/jars/3rdparty/commons-net-3.1.jar
apache-drill-1.11.0/jars/3rdparty/commons-collections-3.2.1.jar
apache-drill-1.11.0/jars/3rdparty/jsp-api-2.1.jar
apache-drill-1.11.0/jars/3rdparty/commons-configuration-1.6.jar
apache-drill-1.11.0/jars/3rdparty/commons-digester-1.8.jar
apache-drill-1.11.0/jars/3rdparty/commons-beanutils-1.7.0.jar
apache-drill-1.11.0/jars/3rdparty/commons-beanutils-core-1.8.0.jar
apache-drill-1.11.0/jars/3rdparty/avro-1.7.7.jar
apache-drill-1.11.0/jars/3rdparty/commons-compress-1.4.1.jar
apache-drill-1.11.0/jars/3rdparty/xz-1.0.jar
apache-drill-1.11.0/jars/3rdparty/gson-2.2.4.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-auth-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/httpclient-4.2.5.jar
apache-drill-1.11.0/jars/3rdparty/httpcore-4.2.4.jar
apache-drill-1.11.0/jars/3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar
apache-drill-1.11.0/jars/3rdparty/apacheds-i18n-2.0.0-M15.jar
apache-drill-1.11.0/jars/3rdparty/api-asn1-api-1.0.0-M20.jar
apache-drill-1.11.0/jars/3rdparty/api-util-1.0.0-M20.jar
apache-drill-1.11.0/jars/3rdparty/jsch-0.1.42.jar
apache-drill-1.11.0/jars/3rdparty/htrace-core-3.1.0-incubating.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-client-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-hdfs-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/leveldbjni-all-1.8.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-app-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-common-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-common-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/stax-api-1.0-2.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-client-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-core-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-server-common-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-shuffle-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-jobclient-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/avro-mapred-1.7.7.jar
apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7.jar
apache-drill-1.11.0/jars/3rdparty/velocity-1.7.jar
apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7-tests.jar
apache-drill-1.11.0/jars/3rdparty/httpdlog-parser-2.4.jar
apache-drill-1.11.0/jars/3rdparty/parser-core-2.4.jar
apache-drill-1.11.0/jars/3rdparty/foodmart-data-json-0.4.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-aws-2.7.1.jar
apache-drill-1.11.0/jars/3rdparty/aws-java-sdk-1.7.4.jar
apache-drill-1.11.0/jars/3rdparty/hbase-client-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-annotations-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/findbugs-annotations-1.3.9-1.jar
apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-protocol-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/jcodings-1.0.8.jar
apache-drill-1.11.0/jars/3rdparty/joni-2.1.2.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.codec-0.9.17.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.io-0.9.17.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.sender-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar
apache-drill-1.11.0/jars/3rdparty/sqlline-1.1.9-drill-r7.jar
apache-drill-1.11.0/jars/3rdparty/kudu-client-1.3.0.jar
apache-drill-1.11.0/jars/3rdparty/interface-annotations-1.3.0.jar
apache-drill-1.11.0/jars/3rdparty/async-1.4.1.jar
apache-drill-1.11.0/jars/3rdparty/hive-metastore-1.2.1.jar
apache-drill-1.11.0/jars/3rdparty/bonecp-0.8.0.RELEASE.jar
apache-drill-1.11.0/jars/3rdparty/derby-10.10.2.0.jar
apache-drill-1.11.0/jars/3rdparty/datanucleus-api-jdo-3.2.6.jar
apache-drill-1.11.0/jars/3rdparty/datanucleus-core-3.2.10.jar
apache-drill-1.11.0/jars/3rdparty/datanucleus-rdbms-3.2.9.jar
apache-drill-1.11.0/jars/3rdparty/jdo-api-3.0.1.jar
apache-drill-1.11.0/jars/3rdparty/jta-1.1.jar
apache-drill-1.11.0/jars/3rdparty/libfb303-0.9.2.jar
apache-drill-1.11.0/jars/3rdparty/libthrift-0.9.2.jar
apache-drill-1.11.0/jars/3rdparty/hive-hbase-handler-1.2.1.jar
apache-drill-1.11.0/jars/3rdparty/hbase-server-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-procedure-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3-tests.jar
apache-drill-1.11.0/jars/3rdparty/hbase-prefix-tree-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-hadoop-compat-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/hbase-hadoop2-compat-1.1.3.jar
apache-drill-1.11.0/jars/3rdparty/metrics-core-2.2.0.jar
apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-1.9.13.jar
apache-drill-1.11.0/jars/3rdparty/disruptor-3.3.0.jar
apache-drill-1.11.0/jars/3rdparty/hive-contrib-1.2.1.jar
apache-drill-1.11.0/jars/3rdparty/esri-geometry-api-1.2.1.jar
apache-drill-1.11.0/jars/3rdparty/json-20090211.jar
apache-drill-1.11.0/jars/3rdparty/hadoop-winutils-2.7.1.zip
apache-drill-1.11.0/jars/3rdparty/kerb-client-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerby-config-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-core-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerby-asn1-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerby-pkix-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerby-util-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-common-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-crypto-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-util-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-simplekdc-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-server-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-identity-1.0.0-RC2.jar
apache-drill-1.11.0/jars/3rdparty/kerb-admin-1.0.0-RC2.jar
apache-drill-1.11.0/jars/ext/zookeeper-3.4.6.jar
apache-drill-1.11.0/winutils/bin/winutils.exe
apache-drill-1.11.0/winutils/bin/hadoop.dll
apache-drill-1.11.0/KEYS
apache-drill-1.11.0/LICENSE
apache-drill-1.11.0/README.md
apache-drill-1.11.0/NOTICE
apache-drill-1.11.0/git.properties
apache-drill-1.11.0/bin/runbit
apache-drill-1.11.0/bin/hadoop-excludes.txt
apache-drill-1.11.0/bin/drillbit.sh
apache-drill-1.11.0/bin/drill-conf
apache-drill-1.11.0/bin/drill-embedded
apache-drill-1.11.0/bin/drill-localhost
apache-drill-1.11.0/bin/drill-config.sh
apache-drill-1.11.0/bin/sqlline
apache-drill-1.11.0/bin/sqlline.bat
apache-drill-1.11.0/bin/submit_plan
apache-drill-1.11.0/conf/drill-override.conf
apache-drill-1.11.0/conf/logback.xml
apache-drill-1.11.0/conf/drill-env.sh
apache-drill-1.11.0/conf/distrib-env.sh
apache-drill-1.11.0/conf/drill-override-example.conf
apache-drill-1.11.0/conf/core-site-example.xml
apache-drill-1.11.0/sample-data/
apache-drill-1.11.0/sample-data/nationsMF/
apache-drill-1.11.0/sample-data/nationsSF/
apache-drill-1.11.0/sample-data/regionsMF/
apache-drill-1.11.0/sample-data/regionsSF/
apache-drill-1.11.0/sample-data/nation.parquet
apache-drill-1.11.0/sample-data/nationsMF/nationsMF.parquet
apache-drill-1.11.0/sample-data/nationsSF/nationsSF.parquet
apache-drill-1.11.0/sample-data/region.parquet
apache-drill-1.11.0/sample-data/regionsMF/regionsMF_Typed.parquet
apache-drill-1.11.0/sample-data/regionsSF/regionsSF.parquet
 
cs



4. 해당 디렉토리를 /usr/local 이하로 복사 혹은 이동합니다.

1
2
$ sudo cp -r ./apache-drill-1.11.0/ /usr/local/
 
cs



5. 해당 디렉토리에 대한 링크를 설정합니다.

1
2
$ sudo ln -sf /usr/local/apache-drill-1.11.0/ /usr/local/drill
 
cs



6. 해당 디렉토리에 대한 권한을 설정합니다.

1
2
$ sudo chown -R hadoop-user:hadoop ./apache-drill-1.11.0/
 
cs



7. drill-override.conf 파일 편집

1
2
$ vi /usr/local/drill/conf/drill-override.conf
 
cs


8. drill-override.conf 파일

8-1. 변경 전

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
 
#  This file tells Drill to consider this module when class path scanning.
#  This file can also include any supplementary configuration information.
#  This file is in HOCON format, see https://github.com/typesafehub/config/blob/master/HOCON.md for more information.
 
# See 'drill-override-example.conf' for example configurations
 
drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "localhost:2181"
}
 
cs


8-2. 변경 후

1
2
3
4
5
drill.exec: {
  cluster-id: "drillbits1",
  zk.connect: "master:2181,secondary:2181,datanode-a:2181,datanode-b:2181,datanode-c:2181"
}
 
cs

* "master:2181" 은 zookeeper 구축 시에 설정한 "호스트명:포트 번호" 로 구성됩니다.

* 구축 시 설정한 값에 맞게 변경한 후 저장합니다.



9. drillbit.sh 파일 실행

1
2
3
$ /usr/local/drill/bin/drillbit.sh start
Starting drillbit, logging to /usr/local/apache-drill-1.11.0/log/drillbit.out
 
cs

* 클러스터 구성에 해당되는 각 노드에 드릴 daemon 을 실행해야 합니다.

* 위 단계를 실행했는데 자바 버전이 1.7 이후 버전임에도 1.7 이후 버전이 아니라는 에러가 발생 시에 아래를 참조하세요.

 -> 자바 버전 에러



10. 이하 나머지 서버 drill 환경 구축

10-1. 위 작업이 완료된 drill 디렉터리를 압축

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
$ sudo tar -cvzf /usr/local/drill/apache-drill-1.11.0.tar.gz /usr/local/drill/apache-drill-1.11.0/
./apache-drill-1.11.0/
./apache-drill-1.11.0/README.md
./apache-drill-1.11.0/bin/
./apache-drill-1.11.0/bin/sqlline
./apache-drill-1.11.0/bin/submit_plan
./apache-drill-1.11.0/bin/drill-conf
./apache-drill-1.11.0/bin/drillbit.sh
./apache-drill-1.11.0/bin/hadoop-excludes.txt
./apache-drill-1.11.0/bin/drill-config.sh
./apache-drill-1.11.0/bin/sqlline.bat
./apache-drill-1.11.0/bin/runbit
./apache-drill-1.11.0/bin/drill-localhost
./apache-drill-1.11.0/bin/drill-embedded
./apache-drill-1.11.0/conf/
./apache-drill-1.11.0/conf/logback.xml
./apache-drill-1.11.0/conf/core-site-example.xml
./apache-drill-1.11.0/conf/drill-override-example.conf
./apache-drill-1.11.0/conf/distrib-env.sh
./apache-drill-1.11.0/conf/drill-override.conf
./apache-drill-1.11.0/conf/drill-env.sh
./apache-drill-1.11.0/git.properties
./apache-drill-1.11.0/log/
./apache-drill-1.11.0/log/drillbit.out
./apache-drill-1.11.0/log/sqlline.log
./apache-drill-1.11.0/log/sqlline_queries.json
./apache-drill-1.11.0/log/drillbit_queries.json
./apache-drill-1.11.0/log/drillbit.log
./apache-drill-1.11.0/NOTICE
./apache-drill-1.11.0/sample-data/
./apache-drill-1.11.0/sample-data/nationsSF/
./apache-drill-1.11.0/sample-data/nationsSF/nationsSF.parquet
./apache-drill-1.11.0/sample-data/region.parquet
./apache-drill-1.11.0/sample-data/regionsMF/
./apache-drill-1.11.0/sample-data/regionsMF/regionsMF_Typed.parquet
./apache-drill-1.11.0/sample-data/nationsMF/
./apache-drill-1.11.0/sample-data/nationsMF/nationsMF.parquet
./apache-drill-1.11.0/sample-data/nation.parquet
./apache-drill-1.11.0/sample-data/regionsSF/
./apache-drill-1.11.0/sample-data/regionsSF/regionsSF.parquet
./apache-drill-1.11.0/LICENSE
./apache-drill-1.11.0/jars/
./apache-drill-1.11.0/jars/jdbc-driver/
./apache-drill-1.11.0/jars/jdbc-driver/drill-jdbc-all-1.11.0.jar
./apache-drill-1.11.0/jars/drill-hive-exec-shaded-1.11.0.jar
./apache-drill-1.11.0/jars/drill-memory-base-1.11.0.jar
./apache-drill-1.11.0/jars/drill-common-1.11.0.jar
./apache-drill-1.11.0/jars/vector-1.11.0.jar
./apache-drill-1.11.0/jars/drill-storage-hbase-1.11.0.jar
./apache-drill-1.11.0/jars/3rdparty/
./apache-drill-1.11.0/jars/3rdparty/javassist-3.16.1-GA.jar
./apache-drill-1.11.0/jars/3rdparty/guava-18.0.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-client-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/protobuf-java-2.5.0.jar
./apache-drill-1.11.0/jars/3rdparty/netty-3.7.0.Final.jar
./apache-drill-1.11.0/jars/3rdparty/asm-debug-all-5.0.3.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-avatica-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-util-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-json-provider-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-math3-3.1.1.jar
./apache-drill-1.11.0/jars/3rdparty/hive-contrib-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/log4j-over-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/esri-geometry-api-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-xml-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-module-jaxb-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-servlet-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-api-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/xmlenc-0.52.jar
./apache-drill-1.11.0/jars/3rdparty/bcprov-jdk15on-1.52.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-prefix-tree-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-generator-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-encoding-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/commons-math-2.2.jar
./apache-drill-1.11.0/jars/3rdparty/velocity-1.7.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-client-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-pkix-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-beanutils-1.7.0.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-continuation-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/hppc-0.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.sender-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/config-1.0.0.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-common-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-lang3-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-core-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar
./apache-drill-1.11.0/jars/3rdparty/mockito-core-1.9.5.jar
./apache-drill-1.11.0/jars/3rdparty/javax.inject-1.jar
./apache-drill-1.11.0/jars/3rdparty/httpclient-4.2.5.jar
./apache-drill-1.11.0/jars/3rdparty/jpam-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/objenesis-1.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-mapper-asl-1.9.11.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-core-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-compress-1.4.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-recipes-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/netty-codec-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/xz-1.0.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-crypto-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-server-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-protocol-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/dom4j-1.6.1.jar
./apache-drill-1.11.0/jars/3rdparty/joda-time-2.9.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.io-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/api-asn1-api-1.0.0-M20.jar
./apache-drill-1.11.0/jars/3rdparty/commons-digester-1.8.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-core-2.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-rdbms-3.2.9.jar
./apache-drill-1.11.0/jars/3rdparty/gson-2.2.4.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-util-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/interface-annotations-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/hamcrest-core-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/stax-api-1.0-2.jar
./apache-drill-1.11.0/jars/3rdparty/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
./apache-drill-1.11.0/jars/3rdparty/kudu-client-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/jsch-0.1.42.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-shuffle-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-webapp-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-core-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-common-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/commons-pool-1.5.4.jar
./apache-drill-1.11.0/jars/3rdparty/univocity-parsers-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/janino-2.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/leveldbjni-all-1.8.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-admin-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-aws-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-simplekdc-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/async-1.4.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-x-discovery-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-json-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-base-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/stringtemplate-3.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/findbugs-annotations-1.3.9-1.jar
./apache-drill-1.11.0/jars/3rdparty/antlr-runtime-3.4.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-format-2.3.0-incubating.jar
./apache-drill-1.11.0/jars/3rdparty/avro-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-server-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/disruptor-3.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-hadoop-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/libthrift-0.9.2.jar
./apache-drill-1.11.0/jars/3rdparty/bonecp-0.8.0.RELEASE.jar
./apache-drill-1.11.0/jars/3rdparty/jcl-over-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/mongo-java-driver-3.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-core-asl-1.9.13.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-core-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/api-util-1.0.0-M20.jar
./apache-drill-1.11.0/jars/3rdparty/httpcore-4.2.4.jar
./apache-drill-1.11.0/jars/3rdparty/hive-metastore-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/jsp-api-2.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-server-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/jta-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/libfb303-0.9.2.jar
./apache-drill-1.11.0/jars/3rdparty/netty-handler-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/commons-beanutils-core-1.8.0.jar
./apache-drill-1.11.0/jars/3rdparty/jdk.tools-1.7.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-procedure-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/foodmart-data-json-0.4.jar
./apache-drill-1.11.0/jars/3rdparty/netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-jvm-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-asn1-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-config-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jsr305-3.0.0.jar
./apache-drill-1.11.0/jars/3rdparty/eigenbase-properties-1.1.5.jar
./apache-drill-1.11.0/jars/3rdparty/commons-io-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/bcpkix-jdk15on-1.52.jar
./apache-drill-1.11.0/jars/3rdparty/sqlline-1.1.9-drill-r7.jar
./apache-drill-1.11.0/jars/3rdparty/validation-api-1.1.0.Final.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-winutils-2.7.1.zip
./apache-drill-1.11.0/jars/3rdparty/commons-codec-1.10.jar
./apache-drill-1.11.0/jars/3rdparty/commons-dbcp-1.4.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-jobclient-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-cli-1.2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-httpclient-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-hadoop-compat-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-util-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-core-3.2.10.jar
./apache-drill-1.11.0/jars/3rdparty/antlr-2.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/derby-10.10.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-servlets-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-linq4j-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/apacheds-i18n-2.0.0-M15.jar
./apache-drill-1.11.0/jars/3rdparty/freemarker-2.3.21.jar
./apache-drill-1.11.0/jars/3rdparty/httpdlog-parser-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jul-to-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/curator-framework-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-hdfs-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-core-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/commons-net-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/paranamer-2.5.6.jar
./apache-drill-1.11.0/jars/3rdparty/jcodings-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/json-simple-1.1.1.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-healthchecks-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-io-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/snappy-java-1.1.2.6.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-server-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-jackson-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-annotations-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/xercesImpl-2.11.0.jar
./apache-drill-1.11.0/jars/3rdparty/aws-java-sdk-1.7.4.jar
./apache-drill-1.11.0/jars/3rdparty/htrace-core-3.1.0-incubating.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-servlets-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/commons-collections-3.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/commons-pool2-2.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/commons-compiler-2.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-databind-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-hadoop2-compat-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-column-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/xalan-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/joni-2.1.2.jar
./apache-drill-1.11.0/jars/3rdparty/hive-hbase-handler-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/msgpack-0.6.6.jar
./apache-drill-1.11.0/jars/3rdparty/xml-apis-1.4.01.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-1.9.13.jar
./apache-drill-1.11.0/jars/3rdparty/slf4j-api-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-app-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-auth-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/netty-transport-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/jcommander-1.30.jar
./apache-drill-1.11.0/jars/3rdparty/json-20090211.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-api-jdo-3.2.6.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-http-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.codec-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/commons-lang-2.6.jar
./apache-drill-1.11.0/jars/3rdparty/serializer-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3-tests.jar
./apache-drill-1.11.0/jars/3rdparty/netty-buffer-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/netty-common-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-core-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/avro-mapred-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-module-afterburner-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-security-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/parser-core-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-json-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/javassist-3.12.1.GA.jar
./apache-drill-1.11.0/jars/3rdparty/jline-2.10.jar
./apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7-tests.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-identity-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jdo-api-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-configuration-1.6.jar
./apache-drill-1.11.0/jars/drill-jdbc-storage-1.11.0.jar
./apache-drill-1.11.0/jars/tpch-sample-data-1.11.0.jar
./apache-drill-1.11.0/jars/drill-jdbc-1.11.0.jar
./apache-drill-1.11.0/jars/classb/
./apache-drill-1.11.0/jars/classb/codemodel-2.6.jar
./apache-drill-1.11.0/jars/classb/aopalliance-repackaged-2.2.0.jar
./apache-drill-1.11.0/jars/classb/hk2-locator-2.2.0.jar
./apache-drill-1.11.0/jars/classb/javax.inject-2.2.0.jar
./apache-drill-1.11.0/jars/classb/activation-1.1.jar
./apache-drill-1.11.0/jars/classb/jersey-container-jetty-http-2.8.jar
./apache-drill-1.11.0/jars/classb/jetty-util-6.1.26.jar
./apache-drill-1.11.0/jars/classb/hk2-utils-2.2.0.jar
./apache-drill-1.11.0/jars/classb/javax.servlet-api-3.1.0.jar
./apache-drill-1.11.0/jars/classb/logback-classic-1.0.13.jar
./apache-drill-1.11.0/jars/classb/jersey-server-2.8.jar
./apache-drill-1.11.0/jars/classb/logback-core-1.0.13.jar
./apache-drill-1.11.0/jars/classb/reflections-0.9.8.jar
./apache-drill-1.11.0/jars/classb/javax.annotation-api-1.2.jar
./apache-drill-1.11.0/jars/classb/jersey-common-2.8.jar
./apache-drill-1.11.0/jars/classb/javax.ws.rs-api-2.0.jar
./apache-drill-1.11.0/jars/classb/jersey-container-servlet-2.8.jar
./apache-drill-1.11.0/jars/classb/osgi-resource-locator-1.0.1.jar
./apache-drill-1.11.0/jars/classb/jersey-client-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-mvc-freemarker-2.8.jar
./apache-drill-1.11.0/jars/classb/jetty-6.1.26.jar
./apache-drill-1.11.0/jars/classb/jersey-guava-2.8.jar
./apache-drill-1.11.0/jars/classb/hk2-api-2.2.0.jar
./apache-drill-1.11.0/jars/classb/jaxb-api-2.2.2.jar
./apache-drill-1.11.0/jars/classb/jersey-media-multipart-2.8.jar
./apache-drill-1.11.0/jars/classb/mimepull-1.9.3.jar
./apache-drill-1.11.0/jars/classb/jersey-container-servlet-core-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-container-jetty-servlet-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-mvc-2.8.jar
./apache-drill-1.11.0/jars/drill-rpc-1.11.0.jar
./apache-drill-1.11.0/jars/drill-kudu-storage-1.11.0.jar
./apache-drill-1.11.0/jars/drill-java-exec-1.11.0.jar
./apache-drill-1.11.0/jars/drill-logical-1.11.0.jar
./apache-drill-1.11.0/jars/drill-mongo-storage-1.11.0.jar
./apache-drill-1.11.0/jars/drill-gis-1.11.0.jar
./apache-drill-1.11.0/jars/ext/
./apache-drill-1.11.0/jars/ext/zookeeper-3.4.6.jar
./apache-drill-1.11.0/jars/drill-protocol-1.11.0.jar
./apache-drill-1.11.0/jars/drill-storage-hive-core-1.11.0.jar
./apache-drill-1.11.0/KEYS
./apache-drill-1.11.0/drillbit.pid
./apache-drill-1.11.0/winutils/
./apache-drill-1.11.0/winutils/bin/
./apache-drill-1.11.0/winutils/bin/hadoop.dll
./apache-drill-1.11.0/winutils/bin/winutils.exe
 
cs

* tar -cvzf [생성할 압축 파일명] [압축할 대상 디렉터리 혹은 파일]


10-2. 압축 파일 생성 여부 확인

1
2
3
4
5
$ ll | grep drill
drwxr-xr-x  8 hadoop-user hadoop      4096 Oct 17 18:42 apache-drill-1.11.0/
-rw-r--r--  1 root        root   198151030 Oct 18 08:57 apache-drill-1.11.0.tar.gz
lrwxrwxrwx  1 root        root          31 Oct 10 16:28 drill -> /usr/local/apache-drill-1.11.0//
 
cs

* 압축 결과에는 이상이 없지만 위의 정보를 보면 drill 사용 계정이 아닌 root 계정의 권한으로 되어 있기 때문에 권한 변경이 필요합니다.


10-3. apache-drill-1.11.0tar.gz 파일 권한 변경

1
2
$ sudo chown hadoop-user:hadoop /usr/local/apache-drill-1.11.0.tar.gz
 
cs

* 각자의 해당 계정에 맞게 변경 후 확인을 진행합니다.


10-4. 권한 변경 여부 확인

1
2
3
4
5
$ ll |grep drill
drwxr-xr-x  8 hadoop-user hadoop      4096 Oct 17 18:42 apache-drill-1.11.0/
-rw-r--r--  1 hadoop-user hadoop 198151030 Oct 18 08:57 apache-drill-1.11.0.tar.gz
lrwxrwxrwx  1 root        root          31 Oct 10 16:28 drill -> /usr/local/apache-drill-1.11.0//
 
cs


※ 다음의 작업에 ssh 설정이 되어 있지 않으면 해당 명령어를 사용할 수 없으므로 아래의 링크를 참조하여 설정을 진행하세요.

 -> ssh 설정


10-5. 클러스터링의 대상이 되는 나머지 서버에 drill 압축 파일 전송

1
2
3
$ scp /usr/local/apache-drill-1.11.0.tar.gz hadoop-user@secondary:~/
apache-drill-1.11.0.tar.gz                                 100%  189MB 189.0MB/s   00:01
 
cs

* 전송 대상이 되는 서버의 drill 사용자 계정의 홈 디렉터리에 전송을 합니다.


10-6. 파일을 전송 후 해당 서버에 접속

1
2
3
4
5
6
7
8
9
10
11
12
13
$ ssh secondary
Welcome to Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64)
 
 * Documentation:  https://help.ubuntu.com
 * Management:     https://landscape.canonical.com
 * Support:        https://ubuntu.com/advantage
 
28 packages can be updated.
15 updates are security updates.
 
 
Last login: Tue Oct 17 15:37:33 2017 from 192.168.10.133
 
cs

* ssh 다음의 secondary 는 접속하려는 대상 서버의 호스트명입니다.


10-7. 접속한 대상 서버에서 전송받은 압축 파일 확인

1
2
3
$ ll |grep drill
-rw-r--r--  1 hadoop-user hadoop 198151030 Oct 18 09:12 apache-drill-1.11.0.tar.gz
 
cs


10-8. 압축 해제

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
$ tar -xvzf ~/apache-drill-1.11.0.tar.gz
./apache-drill-1.11.0/
./apache-drill-1.11.0/README.md
./apache-drill-1.11.0/bin/
./apache-drill-1.11.0/bin/sqlline
./apache-drill-1.11.0/bin/submit_plan
./apache-drill-1.11.0/bin/drill-conf
./apache-drill-1.11.0/bin/drillbit.sh
./apache-drill-1.11.0/bin/hadoop-excludes.txt
./apache-drill-1.11.0/bin/drill-config.sh
./apache-drill-1.11.0/bin/sqlline.bat
./apache-drill-1.11.0/bin/runbit
./apache-drill-1.11.0/bin/drill-localhost
./apache-drill-1.11.0/bin/drill-embedded
./apache-drill-1.11.0/conf/
./apache-drill-1.11.0/conf/logback.xml
./apache-drill-1.11.0/conf/core-site-example.xml
./apache-drill-1.11.0/conf/drill-override-example.conf
./apache-drill-1.11.0/conf/distrib-env.sh
./apache-drill-1.11.0/conf/drill-override.conf
./apache-drill-1.11.0/conf/drill-env.sh
./apache-drill-1.11.0/git.properties
./apache-drill-1.11.0/log/
./apache-drill-1.11.0/log/drillbit.out
./apache-drill-1.11.0/log/sqlline.log
./apache-drill-1.11.0/log/sqlline_queries.json
./apache-drill-1.11.0/log/drillbit_queries.json
./apache-drill-1.11.0/log/drillbit.log
./apache-drill-1.11.0/NOTICE
./apache-drill-1.11.0/sample-data/
./apache-drill-1.11.0/sample-data/nationsSF/
./apache-drill-1.11.0/sample-data/nationsSF/nationsSF.parquet
./apache-drill-1.11.0/sample-data/region.parquet
./apache-drill-1.11.0/sample-data/regionsMF/
./apache-drill-1.11.0/sample-data/regionsMF/regionsMF_Typed.parquet
./apache-drill-1.11.0/sample-data/nationsMF/
./apache-drill-1.11.0/sample-data/nationsMF/nationsMF.parquet
./apache-drill-1.11.0/sample-data/nation.parquet
./apache-drill-1.11.0/sample-data/regionsSF/
./apache-drill-1.11.0/sample-data/regionsSF/regionsSF.parquet
./apache-drill-1.11.0/LICENSE
./apache-drill-1.11.0/jars/
./apache-drill-1.11.0/jars/jdbc-driver/
./apache-drill-1.11.0/jars/jdbc-driver/drill-jdbc-all-1.11.0.jar
./apache-drill-1.11.0/jars/drill-hive-exec-shaded-1.11.0.jar
./apache-drill-1.11.0/jars/drill-memory-base-1.11.0.jar
./apache-drill-1.11.0/jars/drill-common-1.11.0.jar
./apache-drill-1.11.0/jars/vector-1.11.0.jar
./apache-drill-1.11.0/jars/drill-storage-hbase-1.11.0.jar
./apache-drill-1.11.0/jars/3rdparty/
./apache-drill-1.11.0/jars/3rdparty/javassist-3.16.1-GA.jar
./apache-drill-1.11.0/jars/3rdparty/guava-18.0.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-client-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/protobuf-java-2.5.0.jar
./apache-drill-1.11.0/jars/3rdparty/netty-3.7.0.Final.jar
./apache-drill-1.11.0/jars/3rdparty/asm-debug-all-5.0.3.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-avatica-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-util-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-json-provider-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-math3-3.1.1.jar
./apache-drill-1.11.0/jars/3rdparty/hive-contrib-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.formatting-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/log4j-over-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/esri-geometry-api-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.logging.protobuf-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-xml-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-module-jaxb-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-servlet-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-api-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/xmlenc-0.52.jar
./apache-drill-1.11.0/jars/3rdparty/bcprov-jdk15on-1.52.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-prefix-tree-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-generator-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-encoding-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/commons-math-2.2.jar
./apache-drill-1.11.0/jars/3rdparty/velocity-1.7.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-client-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-pkix-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-beanutils-1.7.0.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-continuation-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/hppc-0.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.sender-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/config-1.0.0.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-common-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-lang3-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-core-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/apacheds-kerberos-codec-2.0.0-M15.jar
./apache-drill-1.11.0/jars/3rdparty/mockito-core-1.9.5.jar
./apache-drill-1.11.0/jars/3rdparty/javax.inject-1.jar
./apache-drill-1.11.0/jars/3rdparty/httpclient-4.2.5.jar
./apache-drill-1.11.0/jars/3rdparty/jpam-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.appender.multiplex-core-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/objenesis-1.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-mapper-asl-1.9.11.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.converter-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-core-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-compress-1.4.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-recipes-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/netty-codec-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/xz-1.0.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-crypto-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-server-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-protocol-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/dom4j-1.6.1.jar
./apache-drill-1.11.0/jars/3rdparty/joda-time-2.9.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.io-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/api-asn1-api-1.0.0-M20.jar
./apache-drill-1.11.0/jars/3rdparty/commons-digester-1.8.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-core-2.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-rdbms-3.2.9.jar
./apache-drill-1.11.0/jars/3rdparty/gson-2.2.4.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-util-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/interface-annotations-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/hamcrest-core-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/stax-api-1.0-2.jar
./apache-drill-1.11.0/jars/3rdparty/pentaho-aggdesigner-algorithm-5.1.5-jhyde.jar
./apache-drill-1.11.0/jars/3rdparty/kudu-client-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/jsch-0.1.42.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-shuffle-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-webapp-9.1.1.v20140108.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-core-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-common-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/commons-pool-1.5.4.jar
./apache-drill-1.11.0/jars/3rdparty/univocity-parsers-1.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/janino-2.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/leveldbjni-all-1.8.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-admin-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-aws-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-simplekdc-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/async-1.4.1.jar
./apache-drill-1.11.0/jars/3rdparty/curator-x-discovery-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-json-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-base-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/stringtemplate-3.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/findbugs-annotations-1.3.9-1.jar
./apache-drill-1.11.0/jars/3rdparty/antlr-runtime-3.4.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-format-2.3.0-incubating.jar
./apache-drill-1.11.0/jars/3rdparty/avro-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-server-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/disruptor-3.3.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-annotations-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-hadoop-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/libthrift-0.9.2.jar
./apache-drill-1.11.0/jars/3rdparty/bonecp-0.8.0.RELEASE.jar
./apache-drill-1.11.0/jars/3rdparty/jcl-over-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/mongo-java-driver-3.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-core-asl-1.9.13.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-core-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/api-util-1.0.0-M20.jar
./apache-drill-1.11.0/jars/3rdparty/httpcore-4.2.4.jar
./apache-drill-1.11.0/jars/3rdparty/hive-metastore-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/jsp-api-2.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-server-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/jta-1.1.jar
./apache-drill-1.11.0/jars/3rdparty/libfb303-0.9.2.jar
./apache-drill-1.11.0/jars/3rdparty/netty-handler-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/commons-beanutils-core-1.8.0.jar
./apache-drill-1.11.0/jars/3rdparty/jdk.tools-1.7.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-procedure-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/foodmart-data-json-0.4.jar
./apache-drill-1.11.0/jars/3rdparty/netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-jvm-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-asn1-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/kerby-config-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jsr305-3.0.0.jar
./apache-drill-1.11.0/jars/3rdparty/eigenbase-properties-1.1.5.jar
./apache-drill-1.11.0/jars/3rdparty/commons-io-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/bcpkix-jdk15on-1.52.jar
./apache-drill-1.11.0/jars/3rdparty/sqlline-1.1.9-drill-r7.jar
./apache-drill-1.11.0/jars/3rdparty/validation-api-1.1.0.Final.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-winutils-2.7.1.zip
./apache-drill-1.11.0/jars/3rdparty/commons-codec-1.10.jar
./apache-drill-1.11.0/jars/3rdparty/commons-dbcp-1.4.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-jobclient-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-cli-1.2.jar
./apache-drill-1.11.0/jars/3rdparty/commons-httpclient-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-client-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-hadoop-compat-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-util-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-core-3.2.10.jar
./apache-drill-1.11.0/jars/3rdparty/antlr-2.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/derby-10.10.2.0.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-servlets-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/calcite-linq4j-1.4.0-drill-r21.jar
./apache-drill-1.11.0/jars/3rdparty/apacheds-i18n-2.0.0-M15.jar
./apache-drill-1.11.0/jars/3rdparty/freemarker-2.3.21.jar
./apache-drill-1.11.0/jars/3rdparty/httpdlog-parser-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jul-to-slf4j-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/curator-framework-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-hdfs-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-core-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/commons-net-3.1.jar
./apache-drill-1.11.0/jars/3rdparty/paranamer-2.5.6.jar
./apache-drill-1.11.0/jars/3rdparty/jcodings-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/json-simple-1.1.1.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-healthchecks-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-io-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/snappy-java-1.1.2.6.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-yarn-server-common-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-jackson-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.data.eventsource-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-annotations-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/xercesImpl-2.11.0.jar
./apache-drill-1.11.0/jars/3rdparty/aws-java-sdk-1.7.4.jar
./apache-drill-1.11.0/jars/3rdparty/htrace-core-3.1.0-incubating.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-servlets-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/commons-collections-3.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.lilith.logback.converter-classic-0.9.44.jar
./apache-drill-1.11.0/jars/3rdparty/commons-pool2-2.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/commons-compiler-2.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-databind-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-hadoop2-compat-1.1.3.jar
./apache-drill-1.11.0/jars/3rdparty/parquet-column-1.8.1-drill-r0.jar
./apache-drill-1.11.0/jars/3rdparty/xalan-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/joni-2.1.2.jar
./apache-drill-1.11.0/jars/3rdparty/hive-hbase-handler-1.2.1.jar
./apache-drill-1.11.0/jars/3rdparty/msgpack-0.6.6.jar
./apache-drill-1.11.0/jars/3rdparty/xml-apis-1.4.01.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-jaxrs-1.9.13.jar
./apache-drill-1.11.0/jars/3rdparty/slf4j-api-1.7.6.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-mapreduce-client-app-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hadoop-auth-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/netty-transport-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/jcommander-1.30.jar
./apache-drill-1.11.0/jars/3rdparty/json-20090211.jar
./apache-drill-1.11.0/jars/3rdparty/datanucleus-api-jdo-3.2.6.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-http-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/de.huxhorn.sulky.codec-0.9.17.jar
./apache-drill-1.11.0/jars/3rdparty/commons-lang-2.6.jar
./apache-drill-1.11.0/jars/3rdparty/serializer-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/hbase-common-1.1.3-tests.jar
./apache-drill-1.11.0/jars/3rdparty/netty-buffer-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/netty-common-4.0.27.Final.jar
./apache-drill-1.11.0/jars/3rdparty/protostuff-core-1.0.8.jar
./apache-drill-1.11.0/jars/3rdparty/avro-mapred-1.7.7.jar
./apache-drill-1.11.0/jars/3rdparty/jackson-module-afterburner-2.7.1.jar
./apache-drill-1.11.0/jars/3rdparty/jetty-security-9.1.5.v20140505.jar
./apache-drill-1.11.0/jars/3rdparty/parser-core-2.4.jar
./apache-drill-1.11.0/jars/3rdparty/metrics-json-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/javassist-3.12.1.GA.jar
./apache-drill-1.11.0/jars/3rdparty/jline-2.10.jar
./apache-drill-1.11.0/jars/3rdparty/avro-ipc-1.7.7-tests.jar
./apache-drill-1.11.0/jars/3rdparty/kerb-identity-1.0.0-RC2.jar
./apache-drill-1.11.0/jars/3rdparty/jdo-api-3.0.1.jar
./apache-drill-1.11.0/jars/3rdparty/commons-configuration-1.6.jar
./apache-drill-1.11.0/jars/drill-jdbc-storage-1.11.0.jar
./apache-drill-1.11.0/jars/tpch-sample-data-1.11.0.jar
./apache-drill-1.11.0/jars/drill-jdbc-1.11.0.jar
./apache-drill-1.11.0/jars/classb/
./apache-drill-1.11.0/jars/classb/codemodel-2.6.jar
./apache-drill-1.11.0/jars/classb/aopalliance-repackaged-2.2.0.jar
./apache-drill-1.11.0/jars/classb/hk2-locator-2.2.0.jar
./apache-drill-1.11.0/jars/classb/javax.inject-2.2.0.jar
./apache-drill-1.11.0/jars/classb/activation-1.1.jar
./apache-drill-1.11.0/jars/classb/jersey-container-jetty-http-2.8.jar
./apache-drill-1.11.0/jars/classb/jetty-util-6.1.26.jar
./apache-drill-1.11.0/jars/classb/hk2-utils-2.2.0.jar
./apache-drill-1.11.0/jars/classb/javax.servlet-api-3.1.0.jar
./apache-drill-1.11.0/jars/classb/logback-classic-1.0.13.jar
./apache-drill-1.11.0/jars/classb/jersey-server-2.8.jar
./apache-drill-1.11.0/jars/classb/logback-core-1.0.13.jar
./apache-drill-1.11.0/jars/classb/reflections-0.9.8.jar
./apache-drill-1.11.0/jars/classb/javax.annotation-api-1.2.jar
./apache-drill-1.11.0/jars/classb/jersey-common-2.8.jar
./apache-drill-1.11.0/jars/classb/javax.ws.rs-api-2.0.jar
./apache-drill-1.11.0/jars/classb/jersey-container-servlet-2.8.jar
./apache-drill-1.11.0/jars/classb/osgi-resource-locator-1.0.1.jar
./apache-drill-1.11.0/jars/classb/jersey-client-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-mvc-freemarker-2.8.jar
./apache-drill-1.11.0/jars/classb/jetty-6.1.26.jar
./apache-drill-1.11.0/jars/classb/jersey-guava-2.8.jar
./apache-drill-1.11.0/jars/classb/hk2-api-2.2.0.jar
./apache-drill-1.11.0/jars/classb/jaxb-api-2.2.2.jar
./apache-drill-1.11.0/jars/classb/jersey-media-multipart-2.8.jar
./apache-drill-1.11.0/jars/classb/mimepull-1.9.3.jar
./apache-drill-1.11.0/jars/classb/jersey-container-servlet-core-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-container-jetty-servlet-2.8.jar
./apache-drill-1.11.0/jars/classb/jersey-mvc-2.8.jar
./apache-drill-1.11.0/jars/drill-rpc-1.11.0.jar
./apache-drill-1.11.0/jars/drill-kudu-storage-1.11.0.jar
./apache-drill-1.11.0/jars/drill-java-exec-1.11.0.jar
./apache-drill-1.11.0/jars/drill-logical-1.11.0.jar
./apache-drill-1.11.0/jars/drill-mongo-storage-1.11.0.jar
./apache-drill-1.11.0/jars/drill-gis-1.11.0.jar
./apache-drill-1.11.0/jars/ext/
./apache-drill-1.11.0/jars/ext/zookeeper-3.4.6.jar
./apache-drill-1.11.0/jars/drill-protocol-1.11.0.jar
./apache-drill-1.11.0/jars/drill-storage-hive-core-1.11.0.jar
./apache-drill-1.11.0/KEYS
./apache-drill-1.11.0/drillbit.pid
./apache-drill-1.11.0/winutils/
./apache-drill-1.11.0/winutils/bin/
./apache-drill-1.11.0/winutils/bin/hadoop.dll
./apache-drill-1.11.0/winutils/bin/winutils.exe
 
cs


10-9. 압축 해제 여부 확인

1
2
3
4
$ ll |grep drill
drwxr-xr-x  8 hadoop-user hadoop      4096 Oct 17 18:42 apache-drill-1.11.0/
-rw-r--r--  1 hadoop-user hadoop 198151030 Oct 18 09:12 apache-drill-1.11.0.tar.gz
 
cs


10-10. 적절한 위치로 drill 디렉터리 이동

1
2
$ sudo mv ~/apache-drill-1.11.0 /usr/local/
 
cs


10-11. drill 디렉터리의 링크 생성

1
2
$ sudo ln -sf /usr/local/apache-drill-1.11.0/ /usr/local/drill
 
cs


10-12. drillbit.sh 파일 실행

1
2
3
$ /usr/local/drill/bin/drillbit.sh start
Starting drillbit, logging to /usr/local/apache-drill-1.11.0/log/drillbit.out
 
cs

* 여기까지 진행이 완료된 서버를 제외하고 클러스터링의 대상이 되는 나머지 서버에 위의 과정과 동일하게 작업을 반복합니다.



11. Drillbit 서비스 동작 여부

1
2
3
4
5
6
7
8
9
$ jps
2500 NodeManager
6181 NameNode
24249 RunJar
2539 Jps
31037 QuorumPeerMain
6510 ResourceManager
2479 Drillbit
 
cs

* 10-12번 단계를 실행한 후 위와 같이 drillbit 서비스 동작을 확인합니다.



 위의 과정이 전 노드에 설치 및 설정 완료된 이후 name node에서 아래 단계를 진행하세요.


11. drill-conf 파일 실행

1
2
3
4
5
6
$ /usr/local/drill/bin/drill-conf
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
apache drill 1.11.0
"a drill in the hand is better than two in the bush"
0: jdbc:drill:>
 
cs



12. drill-localhost

1
2
3
4
5
6
$ /usr/local/drill/bin/drill-localhost
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
apache drill 1.11.0
"a little sql for your nosql"
0: jdbc:drill:drillbit=localhost>
 
cs



13. drill 에서 제공하는 Web UI


14. drill 쿼리문 테스트

1
2
3
4
5
6
7
8
9
10
11
12
0: jdbc:drill:drillbit=localhost> select * from sys.drillbits;
+-------------+------------+---------------+------------+----------+----------+
  hostname   | user_port  | control_port  | data_port  | current  | version  |
+-------------+------------+---------------+------------+----------+----------+
 master      | 31010      | 31011         | 31012      | true     | 1.11.0   |
 secondary   | 31010      | 31011         | 31012      | false    | 1.11.0   |
 datanode-b  | 31010      | 31011         | 31012      | false    | 1.11.0   |
 datanode-a  | 31010      | 31011         | 31012      | false    | 1.11.0   |
 datanode-c  | 31010      | 31011         | 31012      | false    | 1.11.0   |
+-------------+------------+---------------+------------+----------+----------+
5 rows selected (0.285 seconds)
 
cs

* current 의 true/false 는 현재 접속한 서버를 표시하고 있습니다.



저작자표시

'Big Data Platform > Drill' 카테고리의 다른 글

[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: Failure setting up ZK for client  (0) 2017.10.18
[에러] Failure in connecting to Drill: org.apache.drill.exec.rpc.RpcException: CONNECTION  (0) 2017.10.18
[에러] Java 1.7 or later is required to run Apache Drill  (0) 2017.10.17

+ Recent posts

티스토리툴바