{"action":"created","issue":{"url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/154","labels_url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/154/labels{/name}","comments_url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/154/comments","events_url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/154/events","html_url":"https://github.com/intel-hadoop/HiBench/issues/154","id":119133159,"number":154,"title":"There are error information:INFO metastore.MetaStoreDirectSql: MySQL check failed, assuming we are not on mysql: Lexical error at line 1, column 5.  Encountered: \"@\" (64), after : \"\". When run HiBench-4.1-branch/workloads/aggregation/spark/java/bin/run.sh","user":{"login":"XianlaiShen","id":16041799,"avatar_url":"https://avatars.githubusercontent.com/u/16041799?v=3","gravatar_id":"","url":"https://api.github.com/users/XianlaiShen","html_url":"https://github.com/XianlaiShen","followers_url":"https://api.github.com/users/XianlaiShen/followers","following_url":"https://api.github.com/users/XianlaiShen/following{/other_user}","gists_url":"https://api.github.com/users/XianlaiShen/gists{/gist_id}","starred_url":"https://api.github.com/users/XianlaiShen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/XianlaiShen/subscriptions","organizations_url":"https://api.github.com/users/XianlaiShen/orgs","repos_url":"https://api.github.com/users/XianlaiShen/repos","events_url":"https://api.github.com/users/XianlaiShen/events{/privacy}","received_events_url":"https://api.github.com/users/XianlaiShen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-27T05:21:54Z","updated_at":"2015-11-27T07:52:11Z","closed_at":null,"body":"Hi,\r\nI have setup Hadoop-2.4.0 Single Node mode,and spark-1.3.0-bin-hadoop2.4, scala-2.11.0,and downloaded the HiBench-4.1-branch,and want to run  the HiBench-4.1-branch/workloads/aggregation/spark/java/bin/run.sh.\r\nit can run sucessfully,and can output  the result,but there are errors information about \"INFO metastore.MetaStoreDirectSql: MySQL check failed, assuming we are not on mysql: Lexical error at line 1, column 5.  Encountered: \"@\" (64), after : \"\".\",as below logs:\r\nIs it normal or not? If it is not right,how can I do the aggregation spark java version test case?\r\nThanks!\r\n\r\nXianlai Shen\r\n\r\n[root@hadoop1 bin]# pwd\r\n/home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/workloads/aggregation/spark/java/bin\r\n[root@hadoop1 bin]# ls\r\nrun.sh\r\n[root@hadoop1 bin]# ./run.sh \r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/conf/00-default-properties.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/conf/00-default-properties_org.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/conf/10-data-scale-profile.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/conf/99-user_defined_properties.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/workloads/aggregation/conf/00-aggregation-default.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/workloads/aggregation/conf/10-aggregation-userdefine.conf\r\nParsing conf: /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/workloads/aggregation/spark/java/java.conf\r\nspark://localhost:7077 localhost\r\nstart JavaSparkAggregation bench\r\nhdfs rm -r: /home/shenxianlai/data_shenxianlai/hadoop/hadoop-2.4.0/bin/hadoop --config /home/shenxianlai/data_shenxianlai/hadoop/hadoop-2.4.0/etc/hadoop fs -rm -r -skipTrash hdfs://localhost:9000/HiBench/Aggregation/Output\r\n15/11/27 13:05:48 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable\r\nDeleted hdfs://localhost:9000/HiBench/Aggregation/Output\r\nExport env: SPARKBENCH_PROPERTIES_FILES=/home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/report/aggregation/spark/java/conf/sparkbench/sparkbench.conf\r\nSubmit Spark job: /home/shenxianlai/data_shenxianlai/spark/spark-1.3.0-bin-hadoop2.4/bin/spark-submit  --properties-file /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/report/aggregation/spark/java/conf/sparkbench/spark.conf --class com.intel.sparkbench.sql.JavaSparkSQLBench --master spark://localhost:7077  /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/src/sparkbench/target/sparkbench-4.0-SNAPSHOT-MR2-spark1.3-jar-with-dependencies.jar JavaAggregation /home/shenxianlai/data_shenxianlai/benchmark/HiBench/HiBench_4.1/HiBench-4.1-branch/report/aggregation/spark/java/conf/../uservisits_aggre.hive\r\n15/11/27 13:05:53 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable\r\n15/11/27 13:06:08 INFO metastore.MetaStoreDirectSql: MySQL check failed, assuming we are not on mysql: Lexical error at line 1, column 5.  Encountered: \"@\" (64), after : \"\".\r\n15/11/27 13:06:19 WARN metastore.ObjectStore: Version information not found in metastore. hive.metastore.schema.verification is not enabled so recording the schema version 0.13.1aa\r\n15/11/27 13:06:46 INFO remote.RemoteActorRefProvider$RemotingTerminator: Remoting shut down.\r\nhdfs du -s: /home/shenxianlai/data_shenxianlai/hadoop/hadoop-2.4.0/bin/hadoop --config /home/shenxianlai/data_shenxianlai/hadoop/hadoop-2.4.0/etc/hadoop fs -du -s hdfs://localhost:9000/HiBench/Aggregation/Output\r\n15/11/27 13:06:53 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable\r\nfinish JavaSparkAggregation bench\r\n[root@hadoop1 bin]# \r\n[root@hadoop1 bin]# \r\n"},"comment":{"url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/comments/160061972","html_url":"https://github.com/intel-hadoop/HiBench/issues/154#issuecomment-160061972","issue_url":"https://api.github.com/repos/intel-hadoop/HiBench/issues/154","id":160061972,"user":{"login":"carsonwang","id":9278199,"avatar_url":"https://avatars.githubusercontent.com/u/9278199?v=3","gravatar_id":"","url":"https://api.github.com/users/carsonwang","html_url":"https://github.com/carsonwang","followers_url":"https://api.github.com/users/carsonwang/followers","following_url":"https://api.github.com/users/carsonwang/following{/other_user}","gists_url":"https://api.github.com/users/carsonwang/gists{/gist_id}","starred_url":"https://api.github.com/users/carsonwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/carsonwang/subscriptions","organizations_url":"https://api.github.com/users/carsonwang/orgs","repos_url":"https://api.github.com/users/carsonwang/repos","events_url":"https://api.github.com/users/carsonwang/events{/privacy}","received_events_url":"https://api.github.com/users/carsonwang/received_events","type":"User","site_admin":false},"created_at":"2015-11-27T07:52:11Z","updated_at":"2015-11-27T07:52:11Z","body":"Do you have additional configuration for the Hive metastore? By default it uses Derby instead of MySQL. If this is the case, I think you can just ignore this INFO message. "}}