[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16432349#comment-16432349 ] Carter Shanklin commented on HIVE-16944: [~bharos92] I'm not working with Hive these days so I won't be able to repro the NPE. Feel free to close if it seems the NPE went away for whatever reason. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16431012#comment-16431012 ] Bharathkrishna Guruvayoor Murali commented on HIVE-16944: - [~pvary] Thanks for pointing that out. In that case, I think the change is not appropriate here, we cannot exit because there could be values provided for url and driver through the config as well. So I guess a code change is needed only if it is throwing a NPE which I could not reproduce. [~cartershanklin] can you make sure if this NPE is still happening? > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16428122#comment-16428122 ] Peter Vary commented on HIVE-16944: --- [~bharos92]: I am not entirely familiar with this part of the code, but I have found this: {code:java} public class HiveSchemaHelper { [..] public static Connection getConnectionToMetastore(String userName, String password, String url, String driver, boolean printInfo, Configuration conf, String schema) throws HiveMetaException { try { url = url == null ? getValidConfVar(ConfVars.CONNECTURLKEY, conf) : url; driver = driver == null ? getValidConfVar(ConfVars.CONNECTION_DRIVER, conf) : driver; } [..] } }{code} Based on this, I think there was a plan to use url, driver from the HiveConf. Is this function is still working? If so, then adding this check is not entirely correct. What do you think? > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16427971#comment-16427971 ] Bharathkrishna Guruvayoor Murali commented on HIVE-16944: - Thanks [~pvary] for looking at the patch. As of now, the options URL and driver are only used when dbType is hive along with metaDbType, which are used only if upgrading the system catalog for Hive. I have added the options metaDbType, URL and driver to the confluence page. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16426637#comment-16426637 ] Peter Vary commented on HIVE-16944: --- Thanks for the patch [~bharos92]! Is the URL, and the driver is only needed when the dbType is hive? If you have time, it would be good to update the [https://cwiki.apache.org/confluence/display/Hive/Hive+Schema+Tool] page with the new parameters and usages. I know you are not the one who added them, but it would be good to have anyway. Thanks, Peter > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16420950#comment-16420950 ] Hive QA commented on HIVE-16944: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12916962/HIVE-16944.1.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 28 failed/errored test(s), 13065 tests executed *Failed tests:* {noformat} TestMinimrCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=93) [infer_bucket_sort_num_buckets.q,infer_bucket_sort_reducers_power_two.q,parallel_orderby.q,bucket_num_reducers_acid.q,infer_bucket_sort_map_operators.q,infer_bucket_sort_merge.q,root_dir_external_table.q,infer_bucket_sort_dyn_part.q,udf_using.q,bucket_num_reducers_acid2.q] TestNegativeCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=95)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16420900#comment-16420900 ] Hive QA commented on HIVE-16944: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 0m 1s{color} | {color:blue} Findbugs executables are not available. {color} | | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 27s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 18s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 11s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 12s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 0m 20s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 18s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 12s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 11s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:red}-1{color} | {color:red} asflicense {color} | {color:red} 0m 13s{color} | {color:red} The patch generated 49 ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 9m 37s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-9927/dev-support/hive-personality.sh | | git revision | master / 52290e7 | | Default Java | 1.8.0_111 | | asflicense | http://104.198.109.242/logs//PreCommit-HIVE-Build-9927/yetus/patch-asflicense-problems.txt | | modules | C: beeline U: beeline | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-9927/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at >
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16420181#comment-16420181 ] Bharathkrishna Guruvayoor Murali commented on HIVE-16944: - Not able to reproduce the NPE when I give: {code:java} $ ./schematool -metaDbType mysql -dbType hive -initSchema {code} But schematool does fail because it is not able to interpret the query for initialization properly. Hence, providing feedback in schematool when the options url/driver are missing when metaDbType is used. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Assignee: Bharathkrishna Guruvayoor Murali >Priority: Major > Attachments: HIVE-16944.1.patch > > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16381164#comment-16381164 ] Ashutosh Chauhan commented on HIVE-16944: - No worries. I am not planning to work on this either. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Priority: Major > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16381147#comment-16381147 ] Vihang Karajgaonkar commented on HIVE-16944: I may not be able to work on this in the near future. I was planning to knock out some of the other JIRAs I have on my plate. But if this is not super-urgent it would be a good starter JIRA for [~bharos92] who is looking to contribute. > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Priority: Major > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16380831#comment-16380831 ] Ashutosh Chauhan commented on HIVE-16944: - [~vihangk1] Will you get a chance to work on this one? > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin >Priority: Major > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16059560#comment-16059560 ] Carter Shanklin commented on HIVE-16944: Also [~vihangk1] if you're interested in setting up INFORMATION_SCHEMA there's a full how-to in HIVE-16941 > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (HIVE-16944) schematool -dbType hive should give some more feedback/assistance
[ https://issues.apache.org/jira/browse/HIVE-16944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16059528#comment-16059528 ] Vihang Karajgaonkar commented on HIVE-16944: I can take a look at this [~cartershanklin]. Curious to understand what is the difference between {{metaDbType}} and {{dbType}} > schematool -dbType hive should give some more feedback/assistance > - > > Key: HIVE-16944 > URL: https://issues.apache.org/jira/browse/HIVE-16944 > Project: Hive > Issue Type: Bug >Reporter: Carter Shanklin > > Given the other ways schematool is used, the most obvious guess I would have > for initializing the Hive schema is: > {code} > schematool -metaDbType mysql -dbType hive -initSchema > {code} > Unfortunately that fails with this NPE: > {code} > Exception in thread "main" java.lang.NullPointerException > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:570) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:564) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:560) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper$HiveCommandParser.(HiveSchemaHelper.java:373) > at > org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getDbCommandParser(HiveSchemaHelper.java:573) > at > org.apache.hive.beeline.HiveSchemaTool.getDbCommandParser(HiveSchemaTool.java:165) > at > org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:101) > at org.apache.hive.beeline.HiveSchemaTool.(HiveSchemaTool.java:90) > at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1166) > 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 org.apache.hadoop.util.RunJar.run(RunJar.java:233) > at org.apache.hadoop.util.RunJar.main(RunJar.java:148) > {code} > Two additional arguments are needed: > -url jdbc:hive2://localhost:1/default -driver > org.apache.hive.jdbc.HiveDriver > If the user does not supply these for dbType hive, schematool should detect > and error out appropriately, plus give an example of what it's looking for. -- This message was sent by Atlassian JIRA (v6.4.14#64029)