Adglob Infosystem Pvt Ltd

Apache Presto – KAFKA Connector

Post author:S K S
Post published:August 20, 2021
Post category:apache
Post comments:0 Comments

The Kafka Connector for Presto allows to access data from Apache Kafka using Presto. Prerequisites Download and install the latest version of the following Apache projects. Apache ZooKeeperApache Kafka Start…

MySQLi – Like Clause

Post author:K Z
Post published:August 20, 2021
Post category:MySQLi
Post comments:0 Comments

We have seen the SQL SELECT command to fetch data from the MySQL table. We can also use a conditional clause called as the WHERE clause to select the required records. A WHERE clause…

Apache Presto – HIVE Connector

Post author:S K S
Post published:August 20, 2021
Post category:apache Hive
Post comments:2 Comments

The Hive connector allows querying data stored in a Hive data warehouse. Prerequisites HadoopHive Hopefully you have installed Hadoop and Hive on your machine. Start all the services one by…

Apache Presto – JMX Connector

Post author:S K S
Post published:August 20, 2021
Post category:apache
Post comments:0 Comments

Java Management Extensions (JMX) gives information about the Java Virtual Machine and software running inside JVM. The JMX connector is used to query JMX information in Presto server. As we…

MySQLi – Delete Query

Post author:K Z
Post published:August 20, 2021
Post category:MySQLi
Post comments:0 Comments

If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well…

XPath – Axes

Post author:k A
Post published:August 20, 2021
Post category:XPath
Post comments:0 Comments

As location path defines the location of a node using absolute or relative path, axes are used to identify elements by their relationship like parent, child, sibling, etc. Axes are named so…

MySQLi – Update Query

Post author:K Z
Post published:August 20, 2021
Post category:MySQLi
Post comments:0 Comments

There may be a requirement where the existing data in a MySQL table needs to be modified. You can do so by using the SQL UPDATE command. This will modify any field…

XPath – Relative Path

Post author:k A
Post published:August 20, 2021
Post category:XPath
Post comments:0 Comments

Location path specifies the location of node in XML document. This path can be absolute or relative. If location path starts with the node that we've selected then it is…

XPath – Absolute Path

Post author:k A
Post published:August 20, 2021
Post category:XPath
Post comments:0 Comments

Location path specifies the location of node in XML document. This path can be absolute or relative. If location path starts with root node or with '/' then it is…

Apache Presto – MySQL Connector

Post author:S K S
Post published:August 20, 2021
Post category:apache MySQL
Post comments:2 Comments

The MySQL connector is used to query an external MySQL database. Prerequisites MySQL server installation. Configuration Settings Hopefully you have installed mysql server on your machine. To enable mysql properties…