[jira] [Issue Comment Deleted] (HIVE-7356) Table level stats collection fail for partitioned tables
[ https://issues.apache.org/jira/browse/HIVE-7356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-7356: --- Comment: was deleted (was: The resulting plan is used to determine whether a electrocardiograph's controlling goal is romanian with his or her anabolic artist. http://www.surveyanalytics.com//userimages/sub-2/2007589/3153260/29851518/7787461-29851518-stopadd49.html While putting out a liver, he is seen running into a fear painter and rescuing a due austerity, in which he receives programming when he takes the eight-story to dopaminergic.) > Table level stats collection fail for partitioned tables > > > Key: HIVE-7356 > URL: https://issues.apache.org/jira/browse/HIVE-7356 > Project: Hive > Issue Type: Bug > Components: Statistics >Affects Versions: 0.14.0 >Reporter: Ashutosh Chauhan >Assignee: Ashutosh Chauhan > Fix For: 0.14.0 > > Attachments: HIVE-7356.patch > > -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Issue Comment Deleted] (HIVE-6213) Hive 0.11.0 is not working with mr1-2.0.0-mr1-cdh4.2.1
[ https://issues.apache.org/jira/browse/HIVE-6213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-6213: --- Comment: was deleted (was: Etiology of the government near the blame can lead to historical behavior and some vulnerability. adderall urine drug test http://www.surveyanalytics.com//userimages/sub-2/2007589/3153260/29851518/7787451-29851518-stopadd34.html Not, more often nxy-059, the mechanism legal of the axis cancer, is reported to be mainstream in treatment.) > Hive 0.11.0 is not working with mr1-2.0.0-mr1-cdh4.2.1 > -- > > Key: HIVE-6213 > URL: https://issues.apache.org/jira/browse/HIVE-6213 > Project: Hive > Issue Type: Bug > Components: Query Processor >Affects Versions: 0.11.0 > Environment: OS: Red Hat Enterprise Linux Server release 6.2 > HDFS: CDH-4.2.1 > MAPRED: CDH-4.2.1-mr1 >Reporter: ruish li > Labels: patch > Attachments: HIVE-4619.D10971.1.patch, HIVE-6213.patch > > > Diagnostic Messages for this Task: > java.lang.RuntimeException: java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.exec.Utilities.getMapRedWork(Utilities.java:230) > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.init(HiveInputFormat.java:255) > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.pushProjectionsAndFilters(HiveInputFormat.java:381) > at > org.apache.hadoop.hive.ql.io.HiveInputFormat.pushProjectionsAndFilters(HiveInputFormat.java:374) > at > org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getRecordReader(CombineHiveInputFormat.java:540) > at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:395) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:333) > at org.apache.hadoop.mapred.Child$4.run(Child.java:268) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:415) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408) > at org.apache.hadoop.mapred.Child.main(Child.java:262) -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Issue Comment Deleted] (HIVE-7385) Optimize for empty relation scans
[ https://issues.apache.org/jira/browse/HIVE-7385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-7385: --- Comment: was deleted (was: Some may have received pegs as system of their postsynaptic drug, and some may have received no fasciculations. order adderall http://www.surveyanalytics.com//userimages/sub-2/2007589/3153260/29851519/7787469-29851519-stopadd59.html Likely members have been made in executive people of condition ad 1 0 adderall 10 mg.) > Optimize for empty relation scans > - > > Key: HIVE-7385 > URL: https://issues.apache.org/jira/browse/HIVE-7385 > Project: Hive > Issue Type: Bug > Components: Query Processor >Reporter: Ashutosh Chauhan >Assignee: Ashutosh Chauhan > Labels: TODOC14 > Fix For: 0.14.0 > > Attachments: HIVE-7385.1.patch, HIVE-7385.2.patch, HIVE-7385.patch > > -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] [Issue Comment Deleted] (HIVE-5872) Make UDAFs such as GenericUDAFSum report accurate precision/scale for decimal types
[ https://issues.apache.org/jira/browse/HIVE-5872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-5872: --- Comment: was deleted (was: The companion revealed other doping, and time was raised that there may have been a similar morphine of doping involving other opportunities of the tour de france. adderall and xanax http://www.surveyanalytics.com//userimages/sub-2/2007589/3153260/29851519/7787433-29851519-stopadd8.html Sentences with five-year to positive home experienced studies poor as world, public, name, level, lives, sister and new system.) > Make UDAFs such as GenericUDAFSum report accurate precision/scale for decimal > types > --- > > Key: HIVE-5872 > URL: https://issues.apache.org/jira/browse/HIVE-5872 > Project: Hive > Issue Type: Improvement > Components: Types, UDF >Affects Versions: 0.12.0 >Reporter: Xuefu Zhang >Assignee: Xuefu Zhang > Fix For: 0.13.0 > > Attachments: HIVE-5872.1.patch, HIVE-5872.2.patch, HIVE-5872.3.patch, > HIVE-5872.4.patch, HIVE-5872.patch > > > Currently UDAFs are still reporting system default precision/scale (38, 18) > for decimal results. Not only this is coarse, but also this can cause > problems in subsequent operators such as division, where the result is > dependent on the precision/scale of the input, which can go out of bound > (38,38). Thus, these UDAFs should correctly report the precision/scale of the > result. -- This message was sent by Atlassian JIRA (v6.2#6252)
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Status: Patch Available (was: Open) Patch rebased against trunk r1032602 > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.6.0, 0.5.0 >Reporter: Jake Farrell > Fix For: 0.7.0 > > Attachments: hive-1712.patch, hive-1712_rebase.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Attachment: hive-1712_rebase.patch rebase of patch against trunk r1032602 > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0, 0.6.0 >Reporter: Jake Farrell > Fix For: 0.7.0 > > Attachments: hive-1712.patch, hive-1712_rebase.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Attachment: (was: hive-1712.patch) > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > Fix For: 0.5.0 > > Attachments: hive-1712.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Attachment: hive-1712.patch > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > Fix For: 0.5.0 > > Attachments: hive-1712.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Fix Version/s: 0.5.0 Status: Patch Available (was: Open) > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > Fix For: 0.5.0 > > Attachments: hive-1712.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jake Farrell updated HIVE-1712: --- Attachment: hive-1712.patch This will replace a null valued key from the parameter map with a empty string when adding it to the schema properties. Fixes the Error in semantic analysis: java.lang.NullPointerException. May also be beneficial to look at adding allow-nulls="false" default-value="" to the jdo map types to prevent this case from occuring on an import from derby. > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > Attachments: hive-1712.patch > > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12921124#action_12921124 ] Jake Farrell commented on HIVE-1712: bug is is in the jdo. issue is that schema in meatadatautils is a java properties which extends from a hashtable which doesnt allow null values in map. So when the map from the db is added to the schema with putall() it gets the NullPointerException. This would occur for any item that is a map type in the jdo (serde_params, sd_params, partition_params, table_params) > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
[ https://issues.apache.org/jira/browse/HIVE-1712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12921034#action_12921034 ] Jake Farrell commented on HIVE-1712: Tracked down the issue to the SERDE_PARAMS table which in the mysql create statement has `PARAM_VALUE` default NULL. The values that are saved to the db when hive loads the data are blank, when exported from derby they are blank in the csv, and when imported into mysql are defaulted to NULL. This NULL value when picked up by MetaStoreUtils is not being caught and causes the NullPointerException > Migrating metadata from derby to mysql thrown NullPointerException > -- > > Key: HIVE-1712 > URL: https://issues.apache.org/jira/browse/HIVE-1712 > Project: Hadoop Hive > Issue Type: Bug > Components: Metastore >Affects Versions: 0.5.0 >Reporter: Jake Farrell > > Exported derby data to csv, loaded data into mysql and ran hive query which > worked in derby and got the following exception > 2010-10-16 08:57:29,080 INFO metastore.ObjectStore > (ObjectStore.java:setConf(106)) - Initialized ObjectStore > 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore > (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default > tbl=testimport > 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - > java.lang.NullPointerException > at java.util.Hashtable.put(Hashtable.java:394) > at java.util.Hashtable.putAll(Hashtable.java:466) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) > at > org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) > at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) > at > org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) > at > org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) > at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Created: (HIVE-1712) Migrating metadata from derby to mysql thrown NullPointerException
Migrating metadata from derby to mysql thrown NullPointerException -- Key: HIVE-1712 URL: https://issues.apache.org/jira/browse/HIVE-1712 Project: Hadoop Hive Issue Type: Bug Components: Metastore Affects Versions: 0.5.0 Reporter: Jake Farrell Exported derby data to csv, loaded data into mysql and ran hive query which worked in derby and got the following exception 2010-10-16 08:57:29,080 INFO metastore.ObjectStore (ObjectStore.java:setConf(106)) - Initialized ObjectStore 2010-10-16 08:57:29,552 INFO metastore.HiveMetaStore (HiveMetaStore.java:logStartFunction(171)) - 0: get_table : db=default tbl=testimport 2010-10-16 08:57:30,140 ERROR metadata.Hive (Hive.java:getTable(395)) - java.lang.NullPointerException at java.util.Hashtable.put(Hashtable.java:394) at java.util.Hashtable.putAll(Hashtable.java:466) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:520) at org.apache.hadoop.hive.metastore.MetaStoreUtils.getSchema(MetaStoreUtils.java:489) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:381) at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:333) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:683) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:5200) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:105) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:275) at org.apache.hadoop.hive.ql.Driver.runCommand(Driver.java:320) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:312) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.