버전: 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 설정이 되어 있지 않으면 해당 명령어를 사용할 수 없으므로 아래의 링크를 참조하여 설정을 진행하세요.
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 는 현재 접속한 서버를 표시하고 있습니다.