HI Gihan, That might solve this issue, but that can cause issues in other features, as MySQL can be shares among many. For example, in our setup RSS doesn't work with if we disable case sensitivity.
Thanks, Bhathiya On Fri, Feb 13, 2015 at 4:54 PM, Gihan Anuruddha <[email protected]> wrote: > Hi Bhathiya, > > Can you try to change the mysql setting in order to ignore the case > sensitivity [1]. > > [1] - > http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html > > Regards, > Gihan > > On Fri, Feb 13, 2015 at 4:47 PM, Bhathiya Jayasekara <[email protected]> > wrote: > >> Hi GIhan, >> >> It works with lowercase tables. I think it's better to fix this issue >> since it's a common use case. (Or is it already fixed in 2.5.0?) >> >> Thanks, >> Bhathiya >> >> On Fri, Feb 13, 2015 at 4:40 PM, Gihan Anuruddha <[email protected]> wrote: >> >>> Hi Bhathiya, >>> >>> AFAIR we had an issue with mysql about lowercase/uppercase. Can you >>> please try that with lowercase table name. >>> >>> Regards, >>> Gihan >>> >>> On Fri, Feb 13, 2015 at 4:31 PM, Bhathiya Jayasekara <[email protected]> >>> wrote: >>> >>>> Hi all, >>>> >>>> I'm getting below error when executing attached hive script. When I run >>>> the same with H2 database it works fine. Issue comes with MySQL. Please >>>> note *highlighted* part. >>>> >>>> Here is MySQL database: >>>> >>>> mysql> emysql> use abc; >>>> Reading table information for completion of table and column names >>>> You can turn off this feature to get a quicker startup with -A >>>> >>>> Database changed >>>> mysql> >>>> mysql> show tables; >>>> +----------------------+ >>>> | Tables_in_abc | >>>> +----------------------+ >>>> | RSSStatsSummaryTable | >>>> +----------------------+ >>>> 1 row in set (0.00 sec) >>>> >>>> [2015-02-13 16:26:27,097] ERROR >>>> {org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation} - Failed to get >>>> total row count >>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table >>>> *'abc.rssstatsformattedtable'* doesn't exist >>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >>>> at >>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) >>>> at >>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) >>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) >>>> at com.mysql.jdbc.Util.getInstance(Util.java:386) >>>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) >>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120) >>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052) >>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503) >>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664) >>>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815) >>>> at >>>> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) >>>> at >>>> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2322) >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.getTotalCount(DBOperation.java:335) >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.input.JDBCSplit.getSplits(JDBCSplit.java:113) >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.input.JDBCDataInputFormat.getSplits(JDBCDataInputFormat.java:41) >>>> at >>>> org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:302) >>>> at >>>> org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getSplits(CombineHiveInputFormat.java:292) >>>> at org.apache.hadoop.mapred.JobClient.writeOldSplits(JobClient.java:933) >>>> at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:925) >>>> at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170) >>>> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:839) >>>> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:792) >>>> 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:1123) >>>> at >>>> org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:792) >>>> at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:766) >>>> at >>>> org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:460) >>>> at org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:733) >>>> 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:606) >>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >>>> java.lang.NullPointerException >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.db.DBOperation.getTotalCount(DBOperation.java:344) >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.input.JDBCSplit.getSplits(JDBCSplit.java:113) >>>> at >>>> org.wso2.carbon.hadoop.hive.jdbc.storage.input.JDBCDataInputFormat.getSplits(JDBCDataInputFormat.java:41) >>>> at >>>> org.apache.hadoop.hive.ql.io.HiveInputFormat.getSplits(HiveInputFormat.java:302) >>>> at >>>> org.apache.hadoop.hive.ql.io.CombineHiveInputFormat.getSplits(CombineHiveInputFormat.java:292) >>>> at org.apache.hadoop.mapred.JobClient.writeOldSplits(JobClient.java:933) >>>> at org.apache.hadoop.mapred.JobClient.writeSplits(JobClient.java:925) >>>> at org.apache.hadoop.mapred.JobClient.access$500(JobClient.java:170) >>>> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:839) >>>> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:792) >>>> 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:1123) >>>> at >>>> org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:792) >>>> at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:766) >>>> at >>>> org.apache.hadoop.hive.ql.exec.ExecDriver.execute(ExecDriver.java:460) >>>> at org.apache.hadoop.hive.ql.exec.ExecDriver.main(ExecDriver.java:733) >>>> 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:606) >>>> at org.apache.hadoop.util.RunJar.main(RunJar.java:156) >>>> Job Submission failed with exception >>>> 'java.lang.NullPointerException(null)'[2015-02-13 16:26:27,101] ERROR >>>> {org.apache.hadoop.hive.ql.exec.ExecDriver} - Job Submission failed with >>>> exception 'java.lang.NullPointerException(null)' >>>> >>>> Any idea why this happens? Should tables used in hive be in lower case >>>> always? >>>> >>>> Thanks, >>>> -- >>>> *Bhathiya Jayasekara* >>>> *Software Engineer,* >>>> *WSO2 inc., http://wso2.com <http://wso2.com>* >>>> >>>> *Phone: +94715478185 <%2B94715478185>* >>>> *LinkedIn: http://www.linkedin.com/in/bhathiyaj >>>> <http://www.linkedin.com/in/bhathiyaj>* >>>> *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* >>>> *Blog: http://movingaheadblog.blogspot.com >>>> <http://movingaheadblog.blogspot.com/>* >>>> >>> >>> >>> >>> -- >>> W.G. Gihan Anuruddha >>> Senior Software Engineer | WSO2, Inc. >>> M: +94772272595 >>> >> >> >> >> -- >> *Bhathiya Jayasekara* >> *Software Engineer,* >> *WSO2 inc., http://wso2.com <http://wso2.com>* >> >> *Phone: +94715478185 <%2B94715478185>* >> *LinkedIn: http://www.linkedin.com/in/bhathiyaj >> <http://www.linkedin.com/in/bhathiyaj>* >> *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* >> *Blog: http://movingaheadblog.blogspot.com >> <http://movingaheadblog.blogspot.com/>* >> > > > > -- > W.G. Gihan Anuruddha > Senior Software Engineer | WSO2, Inc. > M: +94772272595 > -- *Bhathiya Jayasekara* *Software Engineer,* *WSO2 inc., http://wso2.com <http://wso2.com>* *Phone: +94715478185* *LinkedIn: http://www.linkedin.com/in/bhathiyaj <http://www.linkedin.com/in/bhathiyaj>* *Twitter: https://twitter.com/bhathiyax <https://twitter.com/bhathiyax>* *Blog: http://movingaheadblog.blogspot.com <http://movingaheadblog.blogspot.com/>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
