shubhamsachdeva89 commented on issue #66:
URL:
https://github.com/apache/datasketches-postgresql/issues/66#issuecomment-1582795493
Hi Alexander,
Thank you for the quick. I was able to upgrade the datasketches from 1.3 to
1.6.
mbi1d01=# SELECT * FROM pg_extension WHERE extname = 'datasketches';
oid | extname | extowner | extnamespace | extrelocatable |
extversion | extconfig | extcondition
-------+--------------+----------+--------------+----------------+------------+-----------+--------------
17085 | datasketches | 10 | 17081 | t | 1.6.0
| |
(1 row)
I have one doubt. I tried to run below command as suggested in documentation
to test the installation, but it failed with error
mbi1d01=# select cpc_sketch_to_string(cpc_sketch_build(1));
ERROR: function cpc_sketch_build(integer) does not exist
LINE 1: select cpc_sketch_to_string(cpc_sketch_build(1));
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
cpc_sketch_build is present in /datasketches_cpc_sketch.sql but somehow it
is still missing
While installing the so file, datasketches_cpc_sketch.sql was copied to
datasketches--1.6.0.sql
make install
/bin/mkdir -p '/pgbin/mbi1d/14.x/lib/postgresql'
/bin/mkdir -p '/pgbin/mbi1d/14.x/share/postgresql/extension'
/bin/mkdir -p '/pgbin/mbi1d/14.x/share/postgresql/extension'
/bin/install -c -m 755 datasketches.so
'/pgbin/mbi1d/14.x/lib/postgresql/datasketches.so'
**cat sql/datasketches_cpc_sketch.sql sql/datasketches_kll_float_sketch.sql
sql/datasketches_kll_double_sketch.sql sql/datasketches_theta_sketch.sql
sql/datasketches_frequent_strings_sketch.sql sql/datasketches_hll_sketch.sql
sql/datasketches_aod_sketch.sql sql/datasketches_req_float_sketch.sql
sql/datasketches_quantiles_double_sketch.sql > sql/datasketches--1.6.0.sql**
/bin/install -c -m 644 .//datasketches.control
'/pgbin/mbi1d/14.x/share/postgresql/extension/'
/**bin/install -c -m 644 .//sql/datasketches--1.6.0.sql**
.//sql/datasketches--1.3.0--1.4.0.sql .//sql/datasketches--1.4.0--1.5.0.sql
.//sql/datasketches--1.5.0--1.6.0.sql .//sql/datasketches--1.3.0--1.6.0.sql
'/pgbin/mbi1d/14.x/share/postgresql/extension/'
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
