[ https://issues.apache.org/jira/browse/HIVE-7699?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaobing Zhou updated HIVE-7699: -------------------------------- Description: Hive is supposed to support loading data to table from external storage like Azure blob storage. Here's an exampLe: <property> <name>fs.azure.account.key.XXX.blob.core.windows.net</name> <value>CREDENTIAL-KEY</value> </property> is configured into hadoop core-site.xml. bin/hadoop fs works, however if run the query like: LOAD DATA INPATH 'wasb://t...@account-name.blob.core.windows.net/data.txt' OVERWRITE INTO TABLE hivetable; HIVE CLI will complain as FAILED: SemanticException [Error 10028]: Line 1:17 Path is not legal ''wasb://t...@account-name.blob.core.windows.net/data.t xt'': Move from: wasb://t...@account-name.blob.core.windows.net/data.txt to: hdfs://HDFS-HOST:8020/hivetable is not vali d. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict. The stacktrace is at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.applyConstraints(LoadSemanticAnalyzer.java:170) at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:236) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:427) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:323) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:980) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1045) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:916) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:906) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:272) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:427) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:363) at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:460) at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:489) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:772) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:709) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:648) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:212) was: Hive is supposed to support loading data to table from external storage like Azure storage. Here's an exampLe: <property> <name>fs.azure.account.key.XXX.blob.core.windows.net</name> <value>CREDENTIAL-KEY</value> </property> is configured into hadoop core-site.xml. bin/hadoop fs works, however if run the query like: LOAD DATA INPATH 'wasb://t...@account-name.blob.core.windows.net/data.txt' OVERWRITE INTO TABLE hivetable; HIVE CLI will complain as FAILED: SemanticException [Error 10028]: Line 1:17 Path is not legal ''wasb://t...@account-name.blob.core.windows.net/data.t xt'': Move from: wasb://t...@account-name.blob.core.windows.net/data.txt to: hdfs://HDFS-HOST:8020/hivetable is not vali d. Please check that values for params "default.fs.name" and "hive.metastore.warehouse.dir" do not conflict. The stacktrace is at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.applyConstraints(LoadSemanticAnalyzer.java:170) at org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:236) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:427) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:323) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:980) at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1045) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:916) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:906) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:272) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:427) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:363) at org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:460) at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:489) at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:772) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:709) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:648) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.hadoop.util.RunJar.main(RunJar.java:212) > HIVE fails to LOAD DATA INTO TABLE from external storage > --------------------------------------------------------- > > Key: HIVE-7699 > URL: https://issues.apache.org/jira/browse/HIVE-7699 > Project: Hive > Issue Type: Bug > Reporter: Xiaobing Zhou > Assignee: Xiaobing Zhou > > Hive is supposed to support loading data to table from external storage like > Azure blob storage. Here's an exampLe: > <property> > <name>fs.azure.account.key.XXX.blob.core.windows.net</name> > <value>CREDENTIAL-KEY</value> > </property> is configured into hadoop core-site.xml. bin/hadoop fs works, > however if run the query like: > LOAD DATA INPATH 'wasb://t...@account-name.blob.core.windows.net/data.txt' > OVERWRITE INTO TABLE hivetable; > HIVE CLI will complain as > FAILED: SemanticException [Error 10028]: Line 1:17 Path is not legal > ''wasb://t...@account-name.blob.core.windows.net/data.t > xt'': Move from: wasb://t...@account-name.blob.core.windows.net/data.txt to: > hdfs://HDFS-HOST:8020/hivetable is not vali > d. Please check that values for params "default.fs.name" and > "hive.metastore.warehouse.dir" do not conflict. > The stacktrace is > at > org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.applyConstraints(LoadSemanticAnalyzer.java:170) > at > org.apache.hadoop.hive.ql.parse.LoadSemanticAnalyzer.analyzeInternal(LoadSemanticAnalyzer.java:236) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:427) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:323) > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:980) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1045) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:916) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:906) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:272) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:224) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:427) > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:363) > at > org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:460) > at org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:489) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:772) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:709) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:648) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at org.apache.hadoop.util.RunJar.main(RunJar.java:212) -- This message was sent by Atlassian JIRA (v6.2#6252)