1 person found this helpful
Please make sure that you use a the OTN distribution of PGX  to use the GM compiler (see the notice at the top of ).
The compiler is not included in the BDSG distribution of PGX, which is what is preinstalled on the BDL VM.
If you still have issues with the OTN distribution, let me know and I can try to help further.
Thank you for your response dbb-Oracle. Your answer was very helpful towards the solution of the problem.
When trying to compile with the OTN distribution of PGX another issue rose. This time I got the following error:
06:59:55,771 ERROR Task - >> [ERROR] MalformedProgramException on caller-thread: CREATE_ANALYSIS failed
06:59:55,773 ERROR Task - /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.15' not found (required by /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454)
oracle.pgx.api.MalformedProgramException: /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.15' not found (required by /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454)
ERROR: oracle.pgx.api.MalformedProgramException: /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.15' not found (required by /tmp/PGX_ENGINE_g606uht5i328bsgc0vkj089bkm/GM_gm_comp_k9f0kk6kh1ht1afibdlchal454)
libstdc++.so.6 is a symbolic link to libstdc++.so.6.0.13, located in the same directory. The required GLIBCXX_3.4.15 version was missing from there. You can check that by issuing:
$ strings /usr/lib64/libstdc++.so.6.0.13 | grep GLIBCXX_3.4.1
I managed to find a newer version of libstdc++.so.6.0.13 in my BDL Impala directory (/usr/lib/impala/lib), libstdc++.so.6.0.20, which had the GLIBCXX_3.4.15 version. I copied the libstdc++.so.6.0.20 file in /usr/lib64 and redirected the symbolic link to point to it:
$ sudo cp /usr/lib/impala/lib/libstdc++.so.6.0.20 /usr/lib64/
$ sudo rm /usr/lib64/libstdc++.so.6
$ sudo ln -s /usr/lib64/libstdc++.so.6.0.20 /usr/lib64/libstdc++.so.6
I was then able to successfully compile my Green-Marl code!
Excellent, thanks for illustrating the extra steps you needed to run to make things work in your environment.
Hopefully other people will find this information useful.
Maybe clarifying somewhere that the GM compiler is not included in the BDSG distribution of PGX would help others save time in the future (we have been struggling with this for several days now with Panagiotis Konstantinidis). Based on the existing documentation & tutorials, I cannot really see why we should expect this - pointers welcome...
In fact, that's stated in the documentation; see the boxes at the top of the relevant pages:
In any case, thanks for your comment, perhaps that's not visible enough.
We will consider how to make the information more accessible.
I know that the PGX server is there now, I wrote those scripts :-)
But the notice in the docs says that only the OTN distribution of PGX has the GM compiler, and the BDL VM has the BDSG distribution.
Therefore, the installation on the BDL VM does not have the GM compiler.
I agree that it may be made more evident, though.
We'll see what we can do there, hopefully this thread will already be useful to other people to start.
> I know that the PGX server is there now, I wrote those scripts :-)
That's great news! We have found our point of contact!
You may then be interested to know that trying to start the PGX Server from the Start/Stop Services desktop script (screenshot above) will not work; we have to use $PGX_HOME/bin/start-server from a terminal window (Panagiotis Konstantinidis can confirm this).
Also, Panagiotis has opened another issue related to PGX over Zeppelin (which I have also confirmed) at the VM Github pages. Any ideas?
As we are getting ready to dive deep into PGX with Panagiotis, I would greatly appreciate your responsiveness...
Thank you in advance
Please open two new threads in these forums about those two problems and I will try to provide assistance.
I'll try to be as responsive as possible, but I'm really busy these days with several other things, so please be patient :-)