Khurram Faraaz created DRILL-4008:
-------------------------------------
Summary: Difference in commit ID in sys.version and git.properties
file
Key: DRILL-4008
URL: https://issues.apache.org/jira/browse/DRILL-4008
Project: Apache Drill
Issue Type: Bug
Components: Metadata
Affects Versions: 1.2.0, 1.3.0
Environment: 4 node cluster CentOS
Reporter: Khurram Faraaz
commit id in git.properties file under $DRILL_HOME and commit id returned by
sys.version is different.
commit id from git.properties file is,
[root@centos-03 drill-1.3.0]# grep "commit.id" git.properties
git.commit.id.abbrev=e4b94a7
git.commit.id=e4b94a78487f844be4fe71c4b9bf88b16c7f42f7
commit.id from sys.version is different from that of git.properties.
{code}
[root@centos-01 bin]# ./sqlline -u
"jdbc:drill:schema=dfs.tmp:drillbit=10.10.100.203 -n test -p test"
apache drill 1.3.0-SNAPSHOT
"what ever the mind of man can conceive and believe, drill can query"
0: jdbc:drill:schema=dfs.tmp:drillbit=10.10.1> select * from sys.version;
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
| version | commit_id |
commit_message | commit_time | build_email |
build_time |
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
| 1.3.0-SNAPSHOT | cf802fc8333346c268e401ab6ee37310d6c7ccaa | master branch
is now 1.3.0 | 19.10.2015 @ 20:03:14 UTC | Unknown | 29.10.2015 @
04:19:33 UTC |
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
1 row selected (0.353 seconds)
{code}
Running the below command gives me more than one commit id from the jars
{code}
clush -g khurram "cd $DRILL_HOME/jars && ls *.jar | xargs -I% unzip -p %
git.properties | grep commit.id="
{code}
Also if user connects to a Drillbit and queries sys.version and then
disconnects from that Drillbit and reconnects to same Drillbit, sys.version
returns different commit id.
{code}
[root@centos-01 bin]# ./sqlline -u
"jdbc:drill:schema=dfs.tmp:drillbit=10.10.100.201 -n test -p test"
apache drill 1.3.0-SNAPSHOT
"just drill it"
0: jdbc:drill:schema=dfs.tmp:drillbit=10.10.1> select * from sys.version;
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
| version | commit_id |
commit_message | commit_time | build_email |
build_time |
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
| 1.3.0-SNAPSHOT | cf802fc8333346c268e401ab6ee37310d6c7ccaa | master branch
is now 1.3.0 | 19.10.2015 @ 20:03:14 UTC | Unknown | 29.10.2015 @
04:19:33 UTC |
+-----------------+-------------------------------------------+-----------------------------+----------------------------+--------------+----------------------------+
1 row selected (0.451 seconds)
0: jdbc:drill:schema=dfs.tmp:drillbit=10.10.1> !q
Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl
[root@centos-01 bin]# ./sqlline -u
"jdbc:drill:schema=dfs.tmp:drillbit=10.10.100.201 -n test -p test"
apache drill 1.3.0-SNAPSHOT
"got drill?"
0: jdbc:drill:schema=dfs.tmp:drillbit=10.10.1> select * from sys.version;
+-----------------+-------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------------+--------------+----------------------------+
| version | commit_id |
commit_message
| commit_time | build_email | build_time
|
+-----------------+-------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------------+--------------+----------------------------+
| 1.3.0-SNAPSHOT | e4b94a78487f844be4fe71c4b9bf88b16c7f42f7 | DRILL-3937:
Handle the case where min/max columns in metadata cache file are string or
binary values. | 30.10.2015 @ 01:57:33 UTC | Unknown | 31.10.2015 @
01:11:01 UTC |
+-----------------+-------------------------------------------+--------------------------------------------------------------------------------------------------------+----------------------------+--------------+----------------------------+
1 row selected (0.458 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
