math::decimal - General decimal arithmetic
The decimal package provides decimal arithmetic support for both limited precision floating point and arbitrary precision floating point. Additionally, integer arithmetic is supported.
More information and the specifications on which this package depends can be found on the general decimal arithmetic page at http://speleotrove.com/decimal This package provides for:
A new data type decimal which is represented as a list containing sign, mantissa and exponent.
Arithmetic operations on those decimal numbers such as addition, subtraction, multiplication, etc...
Numbers are converted to decimal format using the operation ::math::decimal::fromstr.
Numbers are converted back to string format using the operation ::math::decimal::tostr.
This section shows some simple examples. Since the purpose of this library is to perform decimal math operations, examples may be the simplest way to learn how to work with it and to see the difference between using this package and sticking with expr. Consult the API section of this man page for information about individual procedures.
package require math::decimal # Various operations on two numbers. # We first convert them to decimal format. set a [::math::decimal::fromstr 8.2] set b [::math::decimal::fromstr .2] # Then we perform our operations. Here we add set c [::math::decimal::+ $a $b] # Finally we convert back to string format for presentation to the user. puts [::math::decimal::tostr $c] ; # => will output 8.4 # Other examples # # Subtraction set c [::math::decimal::- $a $b] puts [::math::decimal::tostr $c] ; # => will output 8.0 # Why bother using this instead of simply expr? puts [expr {8.2 + .2}] ; # => will output 8.399999999999999 puts [expr {8.2 - .2}] ; # => will output 7.999999999999999 # See http://speleotrove.com/decimal to learn more about why this happens.
Convert string into a decimal.
Convert decimal into a string representing the number in base 10.
Sets the variable to setting. Valid variables are:
rounding - Method of rounding to use during rescale. Valid methods are round_half_even, round_half_up, round_half_down, round_down, round_up, round_floor, round_ceiling.
precision - Maximum number of digits allowed in mantissa.
extended - Set to 1 for extended mode. 0 for simplified mode.
maxExponent - Maximum value for the exponent. Defaults to 999.
minExponent - Minimum value for the exponent. Default to -998.
Return the sum of the two decimals a and b.
Return the differnece of the two decimals a and b.
Return the product of the two decimals a and b.
Return the quotient of the division between the two decimals a and b.
Return a the integer portion of the quotient of the division between decimals a and b
Return the remainder of the division between the two decimals a and b.
Return the absolute value of the decimal.
Compare the two decimals a and b, returning 0 if a == b, 1 if a > b, and -1 if a < b.
Compare the two decimals a and b, and return a if a >= b, and b if a < b.
Compare the two decimals a and b while ignoring their signs, and return a if abs(a) >= abs(b), and b if abs(a) < abs(b).
Compare the two decimals a and b, and return a if a <= b, and b if a > b.
Compare the two decimals a and b while ignoring their signs, and return a if abs(a) <= abs(b), and b if abs(a) > abs(b).
Return the result from ::math::decimal::+ 0 $a.
Return the result from ::math::decimal::- 0 $a.
Returns a with the sign flipped.
Returns a with the sign set to the sign of the b.
Return the sign of the decimal. The procedure returns 0 if the number is positive, 1 if it's negative.
Return true if decimal value is zero, otherwise false is returned.
Return true if decimal value is NaN (not a number), otherwise false is returned.
Return true if decimal value is Infinite, otherwise false is returned.
Return true if decimal value is finite, otherwise false is returned.
Return the result from first multiplying a by b and then adding c. Rescaling only occurs after completion of all operations. In this way the result may vary from that returned by performing the operations individually.
Rounds decimal to digits number of decimal points with the following rules: Round to the nearest. If equidistant, round so the final digit is even.
Rounds decimal to digits number of decimal points with the following rules: Round to the nearest. If equidistant, round up.
Rounds decimal to digits number of decimal points with the following rules: Round to the nearest. If equidistant, round down.
Rounds decimal to digits number of decimal points with the following rules: Round toward 0. (Truncate)
Rounds decimal to digits number of decimal points with the following rules: Round away from 0
Rounds decimal to digits number of decimal points with the following rules: Round toward -Infinity.
Rounds decimal to digits number of decimal points with the following rules: Round toward Infinity
Rounds decimal to digits number of decimal points with the following rules: Round zero or five away from 0. The same as round-up, except that rounding up only occurs if the digit to be rounded up is 0 or 5, and after overflow the result is the same as for round-down.
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category decimal of the Tcllib Trackers. Please also report any ideas for enhancements you may have for either package and/or documentation.
When proposing code changes, please provide unified diffs, i.e the output of diff -u.
Note further that attachments are strongly preferred over inlined patches. Attachments can be made by going to the Edit form of the ticket immediately after its creation, and then using the left-most button in the secondary navigation bar.
Mathematics
Copyright © 2011 Mark Alston <mark at beernut dot com>


Software Engineer (Data Science)
Sarawak Information Systems Sdn. Bhd.
Working as Software Engineer under Artificial Intelligence Unit of the Company.
My main focus is to conduct research on various machine learning algorithms and their
applications in different domains. I also use MLOps tools and practices to streamline
the development and deployment of machine learning models.
Skills:
- Artificial Intelligence (AI)
- Machine Learning Algorithms
- Research
- MLOps
- Software Development
- Python (Programming Language)
November 2022 - Present
Full Stack Web Developer
Freelance
Project Title: i-Dclare System for Sibu Land and Survey Department
- Designed and developed front and back end of the system using Laravel and MySQL
Referee(s):
- Khalif Amir bin Zakry (Project Supervisor)
July 2022
Project Manager
UNIMAS Entrepreneurship Centre (UEC)
Project Title: UNIMAS eMarketplace
- Led a team of internship students to develop an eCommerce web system for UEC
- Planned and monitor the progress of eCommerce web system
Referee(s):
- Ts. Ahmad Hadinata bin Fauzi (Project Supervisor)
March 2022 - August 2022
Graduate Research Assistant
UNIMAS Research, Innovation and Enterprise Centre (RIEC)
Research Title: Image Classification for Astronomical Archives
- Researched and conducted literature reviews on the current trend in Artificial Intelligence
- Developed, trained, and fine-tuned deep learning models for classifying astronomical object called Planetary Nebulae.
- Developed a web system to predict the output using the trained models
- Configured and deployed an AI web system called CR-Predictor to run locally
Referee(s):
- Associate Professor Ts. Dr Dayang Nurfatimah binti Awang Iskandar (Research Supervisor)
March 2021 - June 2022
Full Stack Web Developer
UNIMAS Holdings Sdn. Bhd.
Project Title: ABD (Red Mark) System for FalTech Engineering Sdn. Bhd.
- Designed and developed a web system that utilizes Google Maps API to calculate the overall cost of each project and monitor its progress based on what is drawn on the map.
Referee(s):
- Associate Professor Ts. Dr Dayang Nurfatimah binti Awang Iskandar (Project Supervisor)
- Ts. Ahmad Hadinata bin Fauzi (Project Supervisor)
February 2021 - September 2021
IoT Developer
UNIMAS (Consultation)
Project Title: Tracking and Identification System of Concrete Samples Using RFID (I-Concrete)
- Designed and developed IoT solution to track and identify concrete samples using RFID.
Referee(s):
- Ts. Ahmad Hadinata bin Fauzi (Project Supervisor)
February 2019
Lab Demonstrator
Faculty of Computer Science and Information Technology, UNIMAS
- Lab demonstrator for Computer Architecture Open Day 2019.
- Taught IoT (Arduino) and Assembly language to undergraduate students.
Referee(s):
- Ts. Ahmad Hadinata bin Fauzi (Computer Architecture Lecturer)
April 2019
Lead Software Developer
Circle Technologies (Startup Internship)
- Lead a team to develop 4 web systems for clients (Prodigy, Hedjraa, Borneo Technology Community, Challenge Factory)
- Designed and developed Android eCommerce application framework
- Planned and 3D designed models for several projects
Referee(s):
- Associate Professor Dr Johari bin Abdullah (Startup Supervisor)
January 2019 - July 2019
Full Stack Android Developer
Belia GPS Android application
- Planned and develop the front-end and back-end of the application using Java, PHP, and SQL
- Developed a REST API for the application to communicate with a MySQL database
Referee(s):
- Associate Professor Dr Johari bin Abdullah (Project Supervisor)
2019


We are so excited to share our special day with you. Please let us know if you can make it, and what events you plan to attend below.
Your Name(s):
Will you be attending our wedding ceremony & reception? accepts with pleasure regretfully declines
Will you be attending the Rockies game with us on Friday, August 16th? yes, can't wait! sadly, no
Please indicate the number of baseball tickets your party needs below: 1 2 3 4 5+
If you selected "5+", please let us know how many tickets you need: tickets:
We hope to see you out on the dance floor. Let us know if you have any song requests: songs:
Your Email:
Send


Preparation time
less than 30 mins
Cooking time
30 mins to 1 hour
Serves
Serves 6-8
Cheat in all the right places with a delicious homemade sausage roll filling encased in ready-made puff pastry.
Heat a small, non-stick frying pan over a medium heat. Add the fennel seeds and toast until aromatic (approximately 30 seconds), shaking the pan occasionally. Use a pestle and mortar to grind the seeds to a powder.
Heat the olive oil in a frying pan set over a medium-low heat. Add the chopped fennel, shallot and garlic. Cook for five minutes, or until the fennel is golden-brown and tender. Add the pancetta to the pan.
In a large bowl, combine the minced pork, toasted fennel seeds, cooled fennel mixture, breadcrumbs, apples, parsley and egg yolk. Season generously with salt and freshly ground black pepper and add a pinch of lemon zest.
Preheat the oven to 200C/400F/Gas 6 and line two large baking trays with baking paper.
Cut the pastry in half widthways, roll each piece out on a lightly floured work surface to a 25cm/10in square. Cut each pastry sheet in half. Divide the mince mixture into four equal portions. Shape each portion into a log and place on the centre of each piece of pastry. Brush the edges of the pastry well with the beaten egg. Fold the pastry over to enclose the filling, overlapping the edges and pressing to seal. Transfer to the lined trays and refrigerate for 20 minutes.
Place the sausage rolls on a chopping board, seam-side down. Cut each roll into three equal pieces. Transfer back to the lined trays, leaving room between the pieces for them to spread during cooking.
Brush the sausage rolls with more beaten egg and sprinkle with sesame seeds. Bake for 15 minutes, then reduce the temperature to 180C/350F/Gas 4. If the trays are on separate shelves swap them around at this point. Bake for a further 10-15 minutes, or until golden-brown.


google-site-verification: googleba4b4cc883e51da8.html
Knowing that a dependable expert you can trust is just a phone call, or a click away, is the greatest service I offer a client. A busy professional needs this ease of mind. I support all your IT-related needs by solving computing problems and issues. I perform computer repairs. I even contact your vendors giving business-owners a single point of contact to resolve any problem, no matter what needs attention. I offer computer and networking services to residential and business customers. Service includes help with setup, troubleshooting, maintenance, training, computer repair, and general help across a wide variety of systems. Repair services can be performed onsite, in Dominick Curatola, or at your business location.
A true technology enthusiast, I am an industry expert and take great pride in my work. I use and carry a full selection of current hardware. I can be reached by phone, email, facebook and twitter. I service the Westchester, NYC and Fairfield areas.


Hi!
I have started my energy monitor proj. Using http://emoncms.org/ website to upload energy meter data but arduino won´t do it.
#include <SPI.h> #include <Ethernet.h> // assign a MAC address for the ethernet controller. // fill in your address here: byte mac[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED}; // fill in an available IP address on your network here, // for manual configuration: IPAddress ip(192, 168, 0, 27); // initialize the library instance: EthernetClient client; //IPAddress server(176,227,193,50); char server[] = "emoncms.org"; unsigned long lastConnectionTime = 0; // last time you connected to the server, in milliseconds boolean lastConnected = false; // state of the connection last time through the main loop const unsigned long postingInterval = 15*1000; // delay between updates, in milliseconds void setup() { // start serial port: Serial.begin(115200); // give the ethernet module time to boot up: delay(1000); // start the Ethernet connection using a fixed IP address and DNS server: Ethernet.begin(mac, ip); // print the Ethernet board/shield's IP address: Serial.print("My IP address: "); Serial.println(Ethernet.localIP()); } void loop() { // if there's incoming data from the net connection. // send it out the serial port. This is for debugging // purposes only: if (client.available()) { char c = client.read(); Serial.print(c); } // if there's no net connection, but there was one last time // through the loop, then stop the client: if (!client.connected() && lastConnected) { Serial.println(); Serial.println("disconnecting."); client.stop(); } // if you're not connected, and ten seconds have passed since // your last connection, then connect again and send data: if(!client.connected() && (millis() - lastConnectionTime > postingInterval)) { httpRequest(); } // store the state of the connection for next time through // the loop: lastConnected = client.connected(); } // this method makes a HTTP connection to the server: void httpRequest() { // if there's a successful connection: if (client.connect(server, 80)) { Serial.println("connecting..."); // send the HTTP GET request: client.print("GET /node/set.json?nodeid=10&data=20,20,20,20&apikey=xxxxxxxxxxxx HTTP/1.1"); client.print("Host:emoncms.org"); client.print("User-Agent: Arduino"); client.print("Connection: close"); client.println(); // note the time that the connection was made: lastConnectionTime = millis(); } else { // if you couldn't make a connection: Serial.println("connection failed"); Serial.println("disconnecting."); client.stop(); } }
It just simple code to get arduino sending data to emoncms.
Server response:
GET /node/set.json?nodeid=10&data=20,20,20,20&apikey=xxxxxxxxxxxxx HTTP/1.1 Host:emoncms.org User-Agent: Arduino Connection: close HTTP/1.1 400 Bad Request Date: Sat, 12 Apr 2014 12:44:48 GMT Server: Apache/2.2.22 (Ubuntu) Vary: Accept-Encoding Content-Length: 329 Connection: close Content-Type: text/html; charset=iso-8859-1 <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">  <title>400 Bad Request</title>
Bad Request

Your browser sent a request that this server could not understand.

 <address>Apache/2.2.22 (Ubuntu) Server at h176-227-193-50.host.redstation.co.uk Port 80</address>
Re: 400 Bad request
Log into emoncms.org and take a look at the Input Api Help Page (on the Input page) which lists the data formats.
I can't see "/node/set.json" on the list.
Re: 400 Bad request
From the http://emoncms.org/node/api
With write apikey: http://emoncms.org/node/set.json?nodeid=10&data=20,20,20,20&apikey=xxxxx...


Actress Shin Min Ah makes trending headlines for her goddess-like beauty in a lavender dress
by sl278Actress Shin Min Ah is causing quite the buzz as netizens rave over her beauty.
The popular actress uploaded a series of candid shots and a video to her personal Instagram with the following caption: "How many outfits did we take pictures of?"
Shin Min Ah is seen displaying her natural beauty as stylists help her get dressed. Netizens particularly noted that the lavender dress suited her well, stating:
"Shin Min Ah is truly lovely."
"Even when they take candid shots like that, she's pretty."
"She never gets old."
What do you think of Shin Min Ah's look?


|
ReactPhysics3D
0.8.0
C++ Physics engine library
|
This class represents the contact between two colliders of the physics world. More...
#include <CollisionCallback.h>
Public Types | |
| enum | EventType { EventType::ContactStart, EventType::ContactStay, EventType::ContactExit } |
| Enumeration EventType that describes the type of contact event. More... | |
Public Member Functions | |
| ContactPair (const ContactPair &contactPair)=default | |
| Copy constructor. | |
| ContactPair & | operator= (const ContactPair &contactPair)=delete |
| Assignment operator. | |
| ~ContactPair ()=default | |
| Destructor. | |
| uint | getNbContactPoints () const |
| Return the number of contact points in the contact pair. More... | |
| ContactPoint | getContactPoint (uint index) const |
| Return a given contact point. More... | |
| CollisionBody * | getBody1 () const |
| Return a pointer to the first body in contact. More... | |
| CollisionBody * | getBody2 () const |
| Return a pointer to the second body in contact. More... | |
| Collider * | getCollider1 () const |
| Return a pointer to the first collider in contact (in body 1) More... | |
| Collider * | getCollider2 () const |
| Return a pointer to the second collider in contact (in body 2) More... | |
| EventType | getEventType () const |
| Return the corresponding type of event for this contact pair. More... | |
Friends | |
| class | CollisionCallback |
This class represents the contact between two colliders of the physics world.
A contact pair contains a list of contact points.
Enumeration EventType that describes the type of contact event.
| CollisionBody * CollisionCallback::ContactPair::getBody1 | ( | ) | const |
Return a pointer to the first body in contact.
| CollisionBody * CollisionCallback::ContactPair::getBody2 | ( | ) | const |
Return a pointer to the second body in contact.
| Collider * CollisionCallback::ContactPair::getCollider1 | ( | ) | const |
Return a pointer to the first collider in contact (in body 1)
| Collider * CollisionCallback::ContactPair::getCollider2 | ( | ) | const |
Return a pointer to the second collider in contact (in body 2)
| CollisionCallback::ContactPoint CollisionCallback::ContactPair::getContactPoint | ( | uint | index | ) | const |
Return a given contact point.
Note that the returned ContactPoint object is only valid during the call of the CollisionCallback::onContact() method.
| index | Index of the contact point to retrieve |
Therefore, you need to get contact data from it and make a copy. Do not make a copy of the ContactPoint object itself because it won't be valid after the CollisionCallback::onContact() call.
| CollisionCallback::ContactPair::EventType CollisionCallback::ContactPair::getEventType | ( | ) | const |
Return the corresponding type of event for this contact pair.
|
inline |
Return the number of contact points in the contact pair.


--- layout: minimal title: "About me" permalink: /about/index.html description: "Some description about Victor Igor..." ---
안녕하세요. 김규현입니다.


reason="NASNets are supported only on TensorFlow")
def test_nasnet():
model = applications.NASNetMobile(weights=None)
assert model.output_shape == (None, 1000)
model = applications.NASNetLarge(weights=None)
assert model.output_shape == (None, 1000)
reason="NASNets are supported only on TensorFlow")
def test_nasnet():
random.seed(time.time())
fun, _ = random.choice(NASNET_LIST)
model = fun(weights=None)
assert model.output_shape == (None, 1000)


@(aboutServerHtml:Option[String])(implicit req:Request[_], msgs:MessagesProvider, pcd:PageCustomizationData) @templates.publicPages("About", views.PublicSection.AboutServer) { @for( about <- aboutServerHtml ) {
Policy Models (formerly: DataTags) is a tool for creating formal models of policies, such as proper handling for a given dataset or benefit entitlements for unemployed people. Originally intended as a way of helping researchers understand the laws and contractual agreements that govern how they can share sensitive data, it may also be used to model other legal and legal-like domains, such as certain types of public policies or scholarly protocols.
Unless otherwise noted, this server, and the organization running it, are not affiliated with the PolicyModels project; they are just only the software developed by the PolicyModels project.
PolicyModels is an open source tool originally developed by the Privacy Tools for Sharing Research Data project at Harvard University. It is currently maintained by the Institute for Quantitative Social Science at Harvard University (IQSS) and by additional organizations.
The goal of this broad, multidisciplinary collaboration between the Center for Research on Computation and Society, the Institute for Quantitative Social Science, the Berkman Center for Internet & Society, and the Data Privacy Lab is to help enable the collection, analysis, and sharing of personal data for research while providing privacy for individual subjects.
More information about the development of the DataTags prototype is available from the DataTags project page. This page also list relevant academic publications.
PolicyModels tools and servers are released under industry-friendly open-source licence (APLv2/MIT).


Note: The following sections in this chapter are intentionally left blank: AD-2.16
LHSM — HEVIZ / BALATON
| 1 | ARP coordinates and site at AD | 464111N 0170933E |
| 2 | Direction and distance from (city) | 1 km SSW from centre of Sarmellek village |
| 3 | Elevation/Reference temperature | 124 M/22° C |
| 4 | Geoid undulation | 46 M |
| 5 | MAG VAR/ annual change | 3° E (2009) / 0.1° increasing |
| 6 | AD Administration, address, telephone, telefax, AFS |
Post:
Heviz-Balaton Airport Repuloter Uzemelteto es Fejleszto Kft. (H-8380 Heviz, Kossuth Lajos u. 1.) H-8391 Sármellék Tel:(+36) 83-200-300, 200-301 Fax:(+36) 83-200-300, 200-301 AFS:LHSMZPZX SITA:SOBHBXH Email<EMAIL_ADDRESS>TWR: Tel:(+36) 83-200-310 Fax:(+36) 83-200-311 |
| 7 | Types of traffic permitted (IFR/VFR) | IFR/VFR/Night VFR |
| 8 | Remarks | Nil |
| 1 | AD Administration |
MON, TUE, WED, THU, FRI, SAT, SUN: 0800-1700 (0700-1600) 01 APR - 17 NOV MON, TUE, WED, THU, FRI, SUN: 0800-1800 (0700-1700) SAT: 0900-2100 (0800-2000) 18 NOV - 31 DEC MON, TUE, WED, THU, FRI, SAT, SUN: 0800-1700 |
| 2 | Customs and immigration* | As AD Administration (Police: H24) |
| 3 | Health and sanitation | On contract |
| 4 | AIS Briefing Office | Nil |
| 5 | ATS Reporting Office (ARO) | Nil |
| 6 | MET Briefing Office | H24 in MET Centre |
| 7 | ATS |
AFIS:
As AD Administration |
| 8 | Fuelling | As AD Administration |
| 9 | Handling | As AD Administration |
| 10 | Security | H24 |
| 11 | De-icing | Nil |
| 12 | Remarks |
Beyond operational hours on prior request
Service fee is 120 EUR/hour |
| 1 | Cargo-handling facilities | Available |
| 2 | Fuel/oil types | AVGAS 100LL, Jet A1 |
| 3 | Fuelling facilities/capacity | 1 kerosene truck (40 tonnes), 1 petrol truck (7.5 tonnes) |
| 4 | De-icing facilities | Nil |
| 5 | Hangar space for visiting aircraft | Nil |
| 6 | Repair facilities for visiting aircraft | Nil |
| 7 | Remarks | Nil |
| 1 | Hotels | Nearest at Heviz and Keszthely town |
| 2 | Restaurants | buffet at the AD, restaurants at Keszthely and Heviz |
| 3 | Transportation | Taxi, rent-a-car, public bus |
| 4 | Medical facilities | First aid at AD, hospital at Keszthely |
| 5 | Bank and Post Office | ATM at Sármellék Post office at Sármellék |
| 6 | Tourist Office | In the city of Heviz and Keszthely and at the airport. |
| 7 | Remarks | Hévíz 12 KM and Keszthely 16 KM from AD |
| 1 | AD category for fire fighting | CAT 3, on request up to CAT 7 |
| 2 | Rescue equipment | 3 fire fighting vehicle, manual tools |
| 3 | Capability for removal of disabled aircraft | Nil |
| 4 | Remarks | Trained staff: 10 |
| 1 | Types of clearing equipment | 3 snow ploughs, 1 snow blower, 1 carbamid spreader |
| 2 | Clearance priorities | RWY, TWY A3, Apron 3 |
| 3 | Remarks | Nil |
| 1 | Apron surface and strength | Apron | Surface | Strength |
| APRON 3 | ASPH | 50R/B/X/T | ||
| 2 | Taxiway width, surface and strength | TWY A3 | Width: | 18 M |
| Surface: | Concrete | |||
| Strength: | ||||
| 3 | Altimeter checkpoint location and elevation | Location: | At RWY THRs | |
| Elevation: | THR RWY16 124.39M THR RWY34 121.52M | |||
| 4 | VOR checkpoints | Nil | ||
| 5 | INS checkpoints | Nil | ||
| 6 | Remarks | Nil |
| 1 | Use of aircraft stand ID signs, TWY guide lines and visual docking/parking guidance system of aircraft stands | Signboards at TWY and RWY intersections and at holding points | |
| 2 | RWY and TWY markings and LGT | RWY: | Designator, THR, centre line |
| TWY: | Centre line markings | ||
| 3 | Stop bars | Nil | |
| 4 | Remarks | Nil |
| I n approach/TKOF areas | In circling area and at AD | Remarks | |||
|---|---|---|---|---|---|
| 1 | 2 | 3 | |||
| RWY NR/Area affected | Obstacle type Elevation Markings/LGT |
Direction (GEO)
Distance (M) |
Obstacle type Elevation Markings/LGT | Coordinates | Nil |
| a | b | c | a | b | |
| 16/APCH |
Chimney
150 M |
151.7
1200 M from THR |
|||
| 16/TKOF |
Water tower
146 M |
154.7
3100 M from THR |
|||
| 16/TKOF |
Steeple
150 M |
184.7
3200 M from THR |
|||
| 34/APCH |
Building
130 M |
168.7
800 M from THR |
|||
| 34/APCH |
Water tower
146 M |
116.7
850 M from THR |
|||
| 34/APCH |
Steeple
150 M |
234.7
1000 M from THR |
|||
| 34/TKOF |
Chimney
150 M |
001.7
1500 M from THR |
| 1 | Associated MET Office | National Meteorological Service, Aeronautical Meteorological Centre |
| 2 | Hours of service | H24 |
| 3 | Office responsible for TAF preparation Periods of validity | National Meteorological Service, Aeronautical Meteorological Centre TAF 9 hours on request |
| 4 |
Type of landing forecast
Interval of issuance |
Landing forecast: 0500-2200 UTC |
| 5 | Briefing/consultation provided | Consultation via phone, fax or telex. See GEN 3.5 |
| 6 |
Flight documentation
Language(s) used |
Charts, abbreviated plain language text Hungarian, English |
| 7 | Charts and other information available for briefing or consultation | Aerodrome reports and forecasts for EUR, area forecasts, met. observations and warnings in Budapest FIR |
| 8 | Supplementary equipment available for providing information | Satellite cloud map covering Europe |
| 9 | ATS Units provided with information | Budapest FIC on request |
| 10 | Additional information | Nil |
| Designations RWY NR | TRUE BRG | Dimensions of RWY (M) | Strength (PCN) and surface of RWY and SWY |
THR coordinates
RWY end coordinates THR geoid undulation |
THR elevation and highest elevation of TDZ of precision APP RWY |
|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 |
| 16 | 165.3° GEO | 2500 x 60 |
60/R/B/X/T
CONC |
464150.16N 0170917.69E
464031.84N 0170947.48E 46 M |
124.4 M |
| 34 | 345.3° GEO | 2500 x 60 |
60/R/B/X/T
CONC |
464031.84N 0170947.48E
464150.16N 0170917.69E 46 M |
122 M |
|
Slope of
RWY - SWY |
SWY dimensions (M) | CWY dimensions (M) | Strip dimensions (M) | OFZ | Remarks |
| 7 | 8 | 9 | 10 | 11 | 12 |
| Nil | |||||
| Nil |
| RWY Designator | TORA (M) | TODA (M) | ASDA (M) | LDA (M) | Remarks |
|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 |
| 16 | 2500 | 2500 | 2500 | 2500 | Nil |
| 34 | 2500 | 2500 | 2500 | 2500 | Nil |
| RWY Designator | APCH LGT type LEN INTST | THR LGT colour WBAR | VASIS (MEHT) PAPI | TDZ LGT LEN | RWY Centre Line LGT Length, spacing, colour, INTST | RWY edge LGT LEN, spacing colour INTST | RWY End LGT colour WBAR | SWY LGT LEN (M) colour | Remarks |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 16 | HIAL CAT I 900 m LIH | Green and barret | PAPI 3 (16.5 M) | Nil | White/red | 2500 M 58 M White / Yellow LIH | Red | Nil | Nil |
| 34 | SALS 420 M LIH | Green | PAPI 3 (16.5 M) | Nil | White/red | 2500 M 58 M White / Yellow LIH | Red | Nil | Nil |
| 1 | ABN/IBN location, characteristics and hours of operation | Nil |
| 2 | LDI location and LGT Anemometer location and LGT | |
| 3 | TWY edge and centre line lighting | Nil |
| 4 | Secondary power supply | Yes for ATS/ AFIS, RWY lighting and navigational aids |
| 5 | Remarks | Nil |
| 1 | Designation and lateral limits | SARMELLEK CTA and SARMELLEK TIZ2 465211N 0164912E - 465233N 0171252E - 463423N 0171944E - 462847N 0171750E - 462539N 0170031E - 465211N 0164912E | SARMELLEK CTR and SARMELLEK TIZ1 465232N 0170443E - 465233N 0171252E - 464035N 0171331E - 463224N 0171903E - 462847N 0171750E - 462659N 0170752E - 463919N 0170630E - 465010N 0165907E - 465232N 0170443E |
| 2 | Vertical limits | CTA and TIZ 2: 9500 FT ALT / 2000 FT ALT | CTR and TIZ 1: 2000 FT ALT / GND |
| 3 | Airspace classification | CTA and CTR: Class D | TIZ 1 and TIZ 2: Class F |
| 4 |
ATS unit call sign
Language(s) |
SÁRMELLÉK TOWER EN, HU | BALATON INFO EN, HU |
| 5 | Transition altitude | 10000 FT | |
| 6 | Remarks | ATC suspended; AFIS (TIZ 1+TIZ 2) See AD 2-LHSM AD-2.3 Air Traffic Advisory Service is not AVBL in the class F airspace LHSM TIZ1, TIZ2. |
| Service designation | Call sign | Frequency | Hours of operation | Remarks |
|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 |
| TWR | HEVIZ / BALATON | 134.575 MHZ | As ATS See AD 2-LHSM AD-2.3 | Reserve FRQ 135.7MHZ |
| AFIS | BALATON INFO | 134.575 MHZ | As ATS See AD 2-LHSM AD-2.3 | Reserve FRQ 135.7MHZ |
|
Type of aid
MAG VAR Type of supported OP (for VOR/ILS/MLS, give declination) |
ID | Frequency | Hours of operation | Position of transmitting antenna coordinates | Elevation of DME transmitting antenna | Remarks |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| ILS 16 (CAT I) | ||||||
| LLZ | SMK | 108.75 MHZ | H24 | 464022.8N 0170950.9E | ||
| GP | 330.35 MHZ | H24 | 464140.6N 0170927.1E | GP angle: 3 | ||
| DME | SMK | 24Y | H24 | 464140.6N 0170927.1E | 443 FT | Co-located with GP 16 |
| DME | SME | 79X | H24 | 463956.6N 0170958.9E | 453 FT | Co-located with L/SME. |
| L | SME | 436 KHZ | H24 | 463956.9N 0171000.7E | 1km from THR RWY 34 |
Taxiing restrictions:
The published Standard Instrument Departure (SID) routes are part of the noise abetment procedures, Therefore strict adherence is compulsory for all IFR flights, except light propeller aircraft until passing 7000 FT QNH.
Flights departing from Sármellék Airport, shall request enroute clearance before take off from the Aerodrome Control Service (further on Tower).The enroute clearance will be delivered by the Tower in standard circumstances after giving the start-up clearance on the parking stand.
Departing aircraft have to follow the procedures included in enroute clearance given before the take-off clearance.
Taxiing shall be carried out as instructed by Tower.
Maximum speed for IFR operation is 250 kt (460 km/h) IAS.
Tower will use one of the Standard Instrument Departures published for IFR flights.
The departure procedures in use are based on those contained in ICAO Doc 8168 OPS/611 (PANS OPS).
The instrument approach procedures are published on Instrument Approach Charts in part AD 2-LHSM.
A visual approach will only be allowed or offered if the visibility is at least 5 km and the cloud-base at least 1500 ft (450m).
ATC clearance for VFR flights within Sármellék CTA and in CTR will be given on the following conditions:
Traffic Pattern:
46 42 22, 485 N; 017 15 52, 785 E
(influx of river Zala)
46 39 37, 458 N; 017 03 45, 026 E
(Meteorological Radar Antenna/ approx. 0,8 NM South East of Dioskál village)
Unless otherwise instructed VFR flights approaching from uncontrolled airspace are required to enter CTR via the designated reporting points.
Holding procedure has to be carried out by the instruction of ATC over the designated reporting points or other point identifiable by the pilot.
Proceed as cleared. If no landing clearance has been received, hold over the designated entry point of the CTR at 2000’ (600 m) AMSL or below for 5 minutes and then make landing on the designated landing area.
Do not take-off, if communication failure experienced before take-off. Return to parking position.
The IFR flights entering controlled airspace after departure, shall obtain enroute clearance before take off.
In standard circumstances the enroute clearance will be delivered by AFIS on the parking stand after start-up.
Departing aircraft have to follow the procedures included in enroute clearance given before the take-off.
Standard Instrument Departures are published in part AD 2-LHSM.
The departure procedures in use are based on those contained in ICAO Doc 8168 OPS/611 (PANS OPS).
The instrument approach procedures are published on Instrument Approach Charts in part AD 2-LHSM.
Contact shall be established with AFIS prior to reaching the area boundary;
AFIS provides information about aerodrome local traffic, „Traffic circuit” available as well as conditions of approach and landing.
Traffic Pattern:
Designated VFR reporting points:
46 42 22, 485 N; 017 15 52, 785 E
(influx of river Zala)
46 39 37, 458 N; 017 03 45, 026 E
(Meteorological Radar Antenna/ approx. 0,8 NM South East of Dioskál village)
When instrument approach is in progress all VFR aircraft operating within the TIZ will be advised to land or hold outside Sármellék TIZ.
Only on workdays between 0800-1600 LT, on work-off days and holidays not authorized.
Maximum two flights with aircraft type IL76 or IL62 daily, furthermore in every 14 days one IL86.
Flights are subject to pay 15% noise surcharge over the standard landing fee.
| AD_2-LHSM-ADC | AERDROME CHART - ICAO |
| AD_2-LHSM-AOC-A | AERODROME OBSTACLE CHART - ICAO |
| AD_2-LHSM-SID16 | STANDARD INSTRUMENT DEPARTURES - ICAO |
| AD_2-LHSM-SID34 | STANDARD INSTRUMENT DEPARTURES - ICAO |
| AD_2-LHSM-ILS16 | INSTRUMENT APPROACH CHART - ICAO |
| AD_2-LHSM-NDB16 | INSTRUMENT APPROACH CHART - ICAO |
| AD_2-LHSM-RNAV-GNSS-16 | RNAV (GNSS) APPROACH CHART |
| AD_2-LHSM-NDB34 | INSTRUMENT APPROACH CHART - ICAO |
| AD_2-LHSM-RNAV-GNSS-34 | RNAV (GNSS) APPROACH CHART |
| AD_2-LHSM-VAC | VISUAL APPROACH CHART - ICAO |


Trivialise complex concepts
Home
About
Blog {Opinion}
Blog {Tech}
GitHub Link
© 2020. All rights reserved.
Devendra Vyas's Blog
Generative vs Discriminative Model
23 May 2020
Related posts
Excerpts from my quarantine
23 Mar 2020
Please enable JavaScript to view the
comments powered by Disqus.


{include file="public/header" }
{include file="public/menu" }
课程名
更换
{include file="public/footer" }


Orders
75
Order(s)
Total Orders
456,092
Naira
Total sum
| Order Number | Meal Ordered | Total price | Customer | Date | |
|---|---|---|---|---|---|
| DHN980 | Rice, Beans, Meat | 1500 | Seun Olakunle |<EMAIL_ADDRESS>| 15th Jan 2019 |
| DHN981 | Plaintain, Beans, Stew | 1500 | Bode Ben |<EMAIL_ADDRESS>| 15th Jan 2019 |
| DHN982 | Eba, Efo riro, fish | 3000 | Tunde Nnamdi |<EMAIL_ADDRESS>| 15th Jan 2019 |
| DHN983 | Fish stew | 1500 | Seyi Olofinjana |<EMAIL_ADDRESS>| 15th Jan 2019 |


{% load admin_urls %} {# This template can be used for both scanner results and scanner query results. Keep it generic. #}


With this platform you can learn and practice Git and discover its features you might haven't been aware of. With all the exercises provided you will rapidly become a Git Master!
If you ask yourself this question, check out a 15-min interactive introduction to Git and come back later. All exercises assume that you already have at least minimum knowledge about Git.


Hot Rod per-cache configuration
Aside from being able to configure a Java Hot Rod client through a compact URI representation, Infinispan 11 brings some additional changes to remote cache configuration.
While remote caches did have some client-side configuration, this was never implemented cleanly, resorting to multiple overloaded variations on the getCache()
method, for example to obtain a transactional cache, or enabling near-caching.
Infinispan 11 now allows specifying per-cache configuration both through the API and through the declarative properties file.
Let’s look at a few examples.
ConfigurationBuilder builder = new ConfigurationBuilder()
.uri("hotrod://<IP_ADDRESS>");
.remoteCache("closecache")
.nearCacheMode(NearCacheMode.INVALIDATED)
.nearCacheMaxEntries(10000)
.remoteCache("txcache")
.transactionMode(TransactionMode.NON_XA);
RemoteCacheManager manager = new RemoteCacheManager(builder.build());
In the above code snippet, we enable near-caching for the cache closecache
and we enable NON_XA transactions on the cache txcache
.
The equivalent hotrod-client.properties
file:
infinispan.client.hotrod.uri=hotrod://<IP_ADDRESS>
infinispan.client.hotrod.cache.closecache.near_cache.mode=INVALIDATED
infinispan.client.hotrod.cache.closecache.near_cache.max_entries=10000
infinispan.client.hotrod.cache.txcache.transaction.transaction_mode=NON_XA
Automatic cache creation
A neat feature that has been implemented as part of per-cache configuration, is the ability to automatically create a cache on the server on first use, if it is missing, by supplying either an existing template or a full-blown configuration.
ConfigurationBuilder builder = new ConfigurationBuilder()
.uri("hotrod://<IP_ADDRESS>");
.remoteCache("mydistcache")
.templateName("org.infinispan.DIST_SYNC");
RemoteCacheManager manager = new RemoteCacheManager(builder.build());
Cache<String, String> cache = manager.getCache("mydistcache");
...
The above example using a properties file would look like:
infinispan.client.hotrod.uri=hotrod://<IP_ADDRESS>
infinispan.client.hotrod.cache.mydistcache.template=org.infinispan.DIST_SYNC


HIT
Music
Music News
Music Festival
Music Reviews
Upcoming Album Releases
Movie
Movie News
Movie Festivals
Upcoming Movie Releases
TV Series
Game
Game News
Game Festivals
Game Reviews
Game Tournament
GAME
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolorem, nulla.
Latest News
MUSIC
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dolorum, possimus.
GAME
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Aperiam, aliquid.
MOVIES
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quibusdam, aperiam totam.
Reviews
MUSIC
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Eum, dignissimos?
GAME
Lorem ipsum dolor sit amet, consectetur adipisicing.
TV SERIES
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Explicabo, ratione.
Festivals
MUSIC
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Accusamus, placeat, nulla.
GAME
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Aperiam, aliquid.
MOVIES
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Quaerat, maxime.
load more articles


Moscow, Abu Dhabi Continuing Talks on Su-35 Delivery to UAE - Russian Gov't Agency
DUBAI (Sputnik) - Russia and the United Arab Emirates (UAE) are continuing talks on the delivery of SU-35 fighter jets to the Middle Eastern country and the joint development of a 5th generation light combat fighter for UAE, Russia's Federal Service for Military-Technical Cooperation said Sunday.
"Talks on the delivery of SU-35 fighter jets and the development of a 5th generation light combat fighter in the interest of the UAE are continuing," the agency's head, Dmitry Shugaev, said.
Russia and the UAE agreed in 2017 to jointly develop a 5th generation light combat fighter jet based on the MiG-29 aircraft. At the time, Sergey Chemezov, the head of the Russian defence giant Rostec, which is developing the project with the UAE Defence Ministry, said it would take seven years to build the jet.


!
! expr - Logical not.
%
expr1 % expr2 - Returns the remainder after expr1
/expr2
.
Examples:
> SELECT 2 % 1.8;
0.2
> SELECT MOD(2, 1.8);
0.2
&
expr1 & expr2 - Returns the result of bitwise AND of expr1
and expr2
.
Examples:
> SELECT 3 & 5;
1
*
expr1 * expr2 - Returns expr1
*expr2
.
Examples:
> SELECT 2 * 3;
6
+
expr1 + expr2 - Returns expr1
+expr2
.
Examples:
> SELECT 1 + 2;
3
-
expr1 - expr2 - Returns expr1
-expr2
.
Examples:
> SELECT 2 - 1;
1
/
expr1 / expr2 - Returns expr1
/expr2
. It always performs floating point division.
Examples:
> SELECT 3 / 2;
1.5
> SELECT 2L / 2L;
1.0
<
expr1 < expr2 - Returns true if expr1
is less than expr2
.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be ordered. For example, map type is not orderable, so it is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 1 < 2;
true
> SELECT 1.1 < '1';
false
> SELECT to_date('2009-07-30 04:17:52') < to_date('2009-07-30 04:17:52');
false
> SELECT to_date('2009-07-30 04:17:52') < to_date('2009-08-01 04:17:52');
true
> SELECT 1 < NULL;
NULL
<=
expr1 <= expr2 - Returns true if expr1
is less than or equal to expr2
.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be ordered. For example, map type is not orderable, so it is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 <= 2;
true
> SELECT 1.0 <= '1';
true
> SELECT to_date('2009-07-30 04:17:52') <= to_date('2009-07-30 04:17:52');
true
> SELECT to_date('2009-07-30 04:17:52') <= to_date('2009-08-01 04:17:52');
true
> SELECT 1 <= NULL;
NULL
<=>
expr1 <=> expr2 - Returns same result as the EQUAL(=) operator for non-null operands, but returns true if both are null, false if one of the them is null.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be used in equality comparison. Map type is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 <=> 2;
true
> SELECT 1 <=> '1';
true
> SELECT true <=> NULL;
false
> SELECT NULL <=> NULL;
true
=
expr1 = expr2 - Returns true if expr1
equals expr2
, or false otherwise.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be used in equality comparison. Map type is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 = 2;
true
> SELECT 1 = '1';
true
> SELECT true = NULL;
NULL
> SELECT NULL = NULL;
NULL
==
expr1 == expr2 - Returns true if expr1
equals expr2
, or false otherwise.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be used in equality comparison. Map type is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 == 2;
true
> SELECT 1 == '1';
true
> SELECT true == NULL;
NULL
> SELECT NULL == NULL;
NULL
>
expr1 > expr2 - Returns true if expr1
is greater than expr2
.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be ordered. For example, map type is not orderable, so it is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 > 1;
true
> SELECT 2 > '1.1';
true
> SELECT to_date('2009-07-30 04:17:52') > to_date('2009-07-30 04:17:52');
false
> SELECT to_date('2009-07-30 04:17:52') > to_date('2009-08-01 04:17:52');
false
> SELECT 1 > NULL;
NULL
>=
expr1 >= expr2 - Returns true if expr1
is greater than or equal to expr2
.
Arguments:
- expr1, expr2 - the two expressions must be same type or can be casted to a common type, and must be a type that can be ordered. For example, map type is not orderable, so it is not supported. For complex types such array/struct, the data types of fields must be orderable.
Examples:
> SELECT 2 >= 1;
true
> SELECT 2.0 >= '2.1';
false
> SELECT to_date('2009-07-30 04:17:52') >= to_date('2009-07-30 04:17:52');
true
> SELECT to_date('2009-07-30 04:17:52') >= to_date('2009-08-01 04:17:52');
false
> SELECT 1 >= NULL;
NULL
^
expr1 ^ expr2 - Returns the result of bitwise exclusive OR of expr1
and expr2
.
Examples:
> SELECT 3 ^ 5;
6
abs
abs(expr) - Returns the absolute value of the numeric value.
Examples:
> SELECT abs(-1);
1
acos
acos(expr) - Returns the inverse cosine (a.k.a. arc cosine) of expr
, as if computed by
java.lang.Math.acos
.
Examples:
> SELECT acos(1);
0.0
> SELECT acos(2);
NaN
add_months
add_months(start_date, num_months) - Returns the date that is num_months
after start_date
.
Examples:
> SELECT add_months('2016-08-31', 1);
2016-09-30
Since: 1.5.0
and
expr1 and expr2 - Logical AND.
approx_count_distinct
approx_count_distinct(expr[, relativeSD]) - Returns the estimated cardinality by HyperLogLog++.
relativeSD
defines the maximum estimation error allowed.
approx_percentile
approx_percentile(col, percentage [, accuracy]) - Returns the approximate percentile value of numeric
column col
at the given percentage. The value of percentage must be between 0.0
and 1.0. The accuracy
parameter (default: 10000) is a positive numeric literal which
controls approximation accuracy at the cost of memory. Higher value of accuracy
yields
better accuracy, 1.0/accuracy
is the relative error of the approximation.
When percentage
is an array, each value of the percentage array must be between 0.0 and 1.0.
In this case, returns the approximate percentile array of column col
at the given
percentage array.
Examples:
> SELECT approx_percentile(10.0, array(0.5, 0.4, 0.1), 100);
[10.0,10.0,10.0]
> SELECT approx_percentile(10.0, 0.5, 100);
10.0
array
array(expr, ...) - Returns an array with the given elements.
Examples:
> SELECT array(1, 2, 3);
[1,2,3]
array_contains
array_contains(array, value) - Returns true if the array contains the value.
Examples:
> SELECT array_contains(array(1, 2, 3), 2);
true
ascii
ascii(str) - Returns the numeric value of the first character of str
.
Examples:
> SELECT ascii('222');
50
> SELECT ascii(2);
50
Since: 1.5.0
asin
asin(expr) - Returns the inverse sine (a.k.a. arc sine) the arc sin of expr
,
as if computed by java.lang.Math.asin
.
Examples:
> SELECT asin(0);
0.0
> SELECT asin(2);
NaN
assert_true
assert_true(expr) - Throws an exception if expr
is not true.
Examples:
> SELECT assert_true(0 < 1);
NULL
atan
atan(expr) - Returns the inverse tangent (a.k.a. arc tangent) of expr
, as if computed by
java.lang.Math.atan
Examples:
> SELECT atan(0);
0.0
atan2
atan2(exprY, exprX) - Returns the angle in radians between the positive x-axis of a plane
and the point given by the coordinates (exprX
, exprY
), as if computed by
java.lang.Math.atan2
.
Arguments:
- exprY - coordinate on y-axis
- exprX - coordinate on x-axis
Examples:
> SELECT atan2(0, 0);
0.0
avg
avg(expr) - Returns the mean calculated from values of a group.
base64
base64(bin) - Converts the argument from a binary bin
to a base 64 string.
Examples:
> SELECT base64('Spark SQL');
U3BhcmsgU1FM
Since: 1.5.0
bigint
bigint(expr) - Casts the value expr
to the target data type bigint
.
bin
bin(expr) - Returns the string representation of the long value expr
represented in binary.
Examples:
> SELECT bin(13);
1101
> SELECT bin(-13);
1111111111111111111111111111111111111111111111111111111111110011
> SELECT bin(13.3);
1101
binary
binary(expr) - Casts the value expr
to the target data type binary
.
bit_length
bit_length(expr) - Returns the bit length of string data or number of bits of binary data.
Examples:
> SELECT bit_length('Spark SQL');
72
Since: 2.3.0
boolean
boolean(expr) - Casts the value expr
to the target data type boolean
.
bround
bround(expr, d) - Returns expr
rounded to d
decimal places using HALF_EVEN rounding mode.
Examples:
> SELECT bround(2.5, 0);
2.0
cast
cast(expr AS type) - Casts the value expr
to the target data type type
.
Examples:
> SELECT cast('10' as int);
10
cbrt
cbrt(expr) - Returns the cube root of expr
.
Examples:
> SELECT cbrt(27.0);
3.0
ceil
ceil(expr) - Returns the smallest integer not smaller than expr
.
Examples:
> SELECT ceil(-0.1);
0
> SELECT ceil(5);
5
ceiling
ceiling(expr) - Returns the smallest integer not smaller than expr
.
Examples:
> SELECT ceiling(-0.1);
0
> SELECT ceiling(5);
5
char
char(expr) - Returns the ASCII character having the binary equivalent to expr
. If n is larger than 256 the result is equivalent to chr(n % 256)
Examples:
> SELECT char(65);
A
Since: 2.3.0
char_length
char_length(expr) - Returns the character length of string data or number of bytes of binary data. The length of string data includes the trailing spaces. The length of binary data includes binary zeros.
Examples:
> SELECT char_length('Spark SQL ');
10
> SELECT CHAR_LENGTH('Spark SQL ');
10
> SELECT CHARACTER_LENGTH('Spark SQL ');
10
Since: 1.5.0
character_length
character_length(expr) - Returns the character length of string data or number of bytes of binary data. The length of string data includes the trailing spaces. The length of binary data includes binary zeros.
Examples:
> SELECT character_length('Spark SQL ');
10
> SELECT CHAR_LENGTH('Spark SQL ');
10
> SELECT CHARACTER_LENGTH('Spark SQL ');
10
Since: 1.5.0
chr
chr(expr) - Returns the ASCII character having the binary equivalent to expr
. If n is larger than 256 the result is equivalent to chr(n % 256)
Examples:
> SELECT chr(65);
A
Since: 2.3.0
coalesce
coalesce(expr1, expr2, ...) - Returns the first non-null argument if exists. Otherwise, null.
Examples:
> SELECT coalesce(NULL, 1, NULL);
1
Since: 1.0.0
collect_list
collect_list(expr) - Collects and returns a list of non-unique elements.
collect_set
collect_set(expr) - Collects and returns a set of unique elements.
concat
concat(str1, str2, ..., strN) - Returns the concatenation of str1, str2, ..., strN.
Examples:
> SELECT concat('Spark', 'SQL');
SparkSQL
concat_ws
concat_ws(sep, [str | array(str)]+) - Returns the concatenation of the strings separated by sep
.
Examples:
> SELECT concat_ws(' ', 'Spark', 'SQL');
Spark SQL
Since: 1.5.0
conv
conv(num, from_base, to_base) - Convert num
from from_base
to to_base
.
Examples:
> SELECT conv('100', 2, 10);
4
> SELECT conv(-10, 16, -10);
-16
corr
corr(expr1, expr2) - Returns Pearson coefficient of correlation between a set of number pairs.
cos
cos(expr) - Returns the cosine of expr
, as if computed by
java.lang.Math.cos
.
Arguments:
- expr - angle in radians
Examples:
> SELECT cos(0);
1.0
cosh
cosh(expr) - Returns the hyperbolic cosine of expr
, as if computed by
java.lang.Math.cosh
.
Arguments:
- expr - hyperbolic angle
Examples:
> SELECT cosh(0);
1.0
cot
cot(expr) - Returns the cotangent of expr
, as if computed by 1/java.lang.Math.cot
.
Arguments:
- expr - angle in radians
Examples:
> SELECT cot(1);
0.6420926159343306
count
count(*) - Returns the total number of retrieved rows, including rows containing null.
count(expr) - Returns the number of rows for which the supplied expression is non-null.
count(DISTINCT expr[, expr...]) - Returns the number of rows for which the supplied expression(s) are unique and non-null.
count_min_sketch
count_min_sketch(col, eps, confidence, seed) - Returns a count-min sketch of a column with the given esp,
confidence and seed. The result is an array of bytes, which can be deserialized to a
CountMinSketch
before usage. Count-min sketch is a probabilistic data structure used for
cardinality estimation using sub-linear space.
covar_pop
covar_pop(expr1, expr2) - Returns the population covariance of a set of number pairs.
covar_samp
covar_samp(expr1, expr2) - Returns the sample covariance of a set of number pairs.
crc32
crc32(expr) - Returns a cyclic redundancy check value of the expr
as a bigint.
Examples:
> SELECT crc32('Spark');
1557323817
cube
cube([col1[, col2 ..]]) - create a multi-dimensional cube using the specified columns so that we can run aggregation on them.
Examples:
> SELECT name, age, count(*) FROM VALUES (2, 'Alice'), (5, 'Bob') people(age, name) GROUP BY cube(name, age);
NULL 2 1
NULL NULL 2
Alice 2 1
Bob 5 1
NULL 5 1
Bob NULL 1
Alice NULL 1
Since: 2.0.0
cume_dist
cume_dist() - Computes the position of a value relative to all values in the partition.
current_database
current_database() - Returns the current database.
Examples:
> SELECT current_database();
default
current_date
current_date() - Returns the current date at the start of query evaluation.
Since: 1.5.0
current_timestamp
current_timestamp() - Returns the current timestamp at the start of query evaluation.
Since: 1.5.0
date
date(expr) - Casts the value expr
to the target data type date
.
date_add
date_add(start_date, num_days) - Returns the date that is num_days
after start_date
.
Examples:
> SELECT date_add('2016-07-30', 1);
2016-07-31
Since: 1.5.0
date_format
date_format(timestamp, fmt) - Converts timestamp
to a value of string in the format specified by the date format fmt
.
Examples:
> SELECT date_format('2016-04-08', 'y');
2016
Since: 1.5.0
date_sub
date_sub(start_date, num_days) - Returns the date that is num_days
before start_date
.
Examples:
> SELECT date_sub('2016-07-30', 1);
2016-07-29
Since: 1.5.0
date_trunc
date_trunc(fmt, ts) - Returns timestamp ts
truncated to the unit specified by the format model fmt
.
fmt
should be one of ["YEAR", "YYYY", "YY", "MON", "MONTH", "MM", "DAY", "DD", "HOUR", "MINUTE", "SECOND", "WEEK", "QUARTER"]
Examples:
> SELECT date_trunc('YEAR', '2015-03-05T09:32:05.359');
2015-01-01 00:00:00
> SELECT date_trunc('MM', '2015-03-05T09:32:05.359');
2015-03-01 00:00:00
> SELECT date_trunc('DD', '2015-03-05T09:32:05.359');
2015-03-05 00:00:00
> SELECT date_trunc('HOUR', '2015-03-05T09:32:05.359');
2015-03-05 09:00:00
Since: 2.3.0
datediff
datediff(endDate, startDate) - Returns the number of days from startDate
to endDate
.
Examples:
> SELECT datediff('2009-07-31', '2009-07-30');
1
> SELECT datediff('2009-07-30', '2009-07-31');
-1
Since: 1.5.0
day
day(date) - Returns the day of month of the date/timestamp.
Examples:
> SELECT day('2009-07-30');
30
Since: 1.5.0
dayofmonth
dayofmonth(date) - Returns the day of month of the date/timestamp.
Examples:
> SELECT dayofmonth('2009-07-30');
30
Since: 1.5.0
dayofweek
dayofweek(date) - Returns the day of the week for date/timestamp (1 = Sunday, 2 = Monday, ..., 7 = Saturday).
Examples:
> SELECT dayofweek('2009-07-30');
5
Since: 2.3.0
dayofyear
dayofyear(date) - Returns the day of year of the date/timestamp.
Examples:
> SELECT dayofyear('2016-04-09');
100
Since: 1.5.0
decimal
decimal(expr) - Casts the value expr
to the target data type decimal
.
decode
decode(bin, charset) - Decodes the first argument using the second argument character set.
Examples:
> SELECT decode(encode('abc', 'utf-8'), 'utf-8');
abc
Since: 1.5.0
degrees
degrees(expr) - Converts radians to degrees.
Arguments:
- expr - angle in radians
Examples:
> SELECT degrees(3.141592653589793);
180.0
dense_rank
dense_rank() - Computes the rank of a value in a group of values. The result is one plus the previously assigned rank value. Unlike the function rank, dense_rank will not produce gaps in the ranking sequence.
double
double(expr) - Casts the value expr
to the target data type double
.
e
e() - Returns Euler's number, e.
Examples:
> SELECT e();
2.718281828459045
elt
elt(n, input1, input2, ...) - Returns the n
-th input, e.g., returns input2
when n
is 2.
Examples:
> SELECT elt(1, 'scala', 'java');
scala
Since: 2.0.0
encode
encode(str, charset) - Encodes the first argument using the second argument character set.
Examples:
> SELECT encode('abc', 'utf-8');
abc
Since: 1.5.0
exp
exp(expr) - Returns e to the power of expr
.
Examples:
> SELECT exp(0);
1.0
explode
explode(expr) - Separates the elements of array expr
into multiple rows, or the elements of map expr
into multiple rows and columns.
Examples:
> SELECT explode(array(10, 20));
10
20
explode_outer
explode_outer(expr) - Separates the elements of array expr
into multiple rows, or the elements of map expr
into multiple rows and columns.
Examples:
> SELECT explode_outer(array(10, 20));
10
20
expm1
expm1(expr) - Returns exp(expr
) - 1.
Examples:
> SELECT expm1(0);
0.0
factorial
factorial(expr) - Returns the factorial of expr
. expr
is [0..20]. Otherwise, null.
Examples:
> SELECT factorial(5);
120
find_in_set
find_in_set(str, str_array) - Returns the index (1-based) of the given string (str
) in the comma-delimited list (str_array
).
Returns 0, if the string was not found or if the given string (str
) contains a comma.
Examples:
> SELECT find_in_set('ab','abc,b,ab,c,def');
3
Since: 1.5.0
first
first(expr[, isIgnoreNull]) - Returns the first value of expr
for a group of rows.
If isIgnoreNull
is true, returns only non-null values.
first_value
first_value(expr[, isIgnoreNull]) - Returns the first value of expr
for a group of rows.
If isIgnoreNull
is true, returns only non-null values.
float
float(expr) - Casts the value expr
to the target data type float
.
floor
floor(expr) - Returns the largest integer not greater than expr
.
Examples:
> SELECT floor(-0.1);
-1
> SELECT floor(5);
5
format_number
format_number(expr1, expr2) - Formats the number expr1
like '#,###,###.##', rounded to expr2
decimal places. If expr2
is 0, the result has no decimal point or fractional part.
This is supposed to function like MySQL's FORMAT.
Examples:
> SELECT format_number(12332.123456, 4);
12,332.1235
Since: 1.5.0
format_string
format_string(strfmt, obj, ...) - Returns a formatted string from printf-style format strings.
Examples:
> SELECT format_string("Hello World %d %s", 100, "days");
Hello World 100 days
Since: 1.5.0
from_json
from_json(jsonStr, schema[, options]) - Returns a struct value with the given jsonStr
and schema
.
Examples:
> SELECT from_json('{"a":1, "b":0.8}', 'a INT, b DOUBLE');
{"a":1, "b":0.8}
> SELECT from_json('{"time":"26/08/2015"}', 'time Timestamp', map('timestampFormat', 'dd/MM/yyyy'));
{"time":"2015-08-26 00:00:00.0"}
Since: 2.2.0
from_unixtime
from_unixtime(unix_time, format) - Returns unix_time
in the specified format
.
Examples:
> SELECT from_unixtime(0, 'yyyy-MM-dd HH:mm:ss');
1970-01-01 00:00:00
Since: 1.5.0
from_utc_timestamp
from_utc_timestamp(timestamp, timezone) - Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in UTC, and renders that time as a timestamp in the given time zone. For example, 'GMT+1' would yield '2017-07-14 03:40:00.0'.
Examples:
> SELECT from_utc_timestamp('2016-08-31', 'Asia/Seoul');
2016-08-31 09:00:00
Since: 1.5.0
get_json_object
get_json_object(json_txt, path) - Extracts a json object from path
.
Examples:
> SELECT get_json_object('{"a":"b"}', '$.a');
b
greatest
greatest(expr, ...) - Returns the greatest value of all parameters, skipping null values.
Examples:
> SELECT greatest(10, 9, 2, 4, 3);
10
grouping
grouping(col) - indicates whether a specified column in a GROUP BY is aggregated or not, returns 1 for aggregated or 0 for not aggregated in the result set.",
Examples:
> SELECT name, grouping(name), sum(age) FROM VALUES (2, 'Alice'), (5, 'Bob') people(age, name) GROUP BY cube(name);
Alice 0 2
NULL 1 7
Bob 0 5
Since: 2.0.0
grouping_id
grouping_id([col1[, col2 ..]]) - returns the level of grouping, equals to
(grouping(c1) << (n-1)) + (grouping(c2) << (n-2)) + ... + grouping(cn)
Examples:
> SELECT name, grouping_id(), sum(age), avg(height) FROM VALUES (2, 'Alice', 165), (5, 'Bob', 180) people(age, name, height) GROUP BY cube(name, height);
NULL 2 2 165.0
Alice 0 2 165.0
NULL 2 5 180.0
NULL 3 7 172.5
Bob 0 5 180.0
Bob 1 5 180.0
Alice 1 2 165.0
Note:
Input columns should match with grouping columns exactly, or empty (means all the grouping columns).
Since: 2.0.0
hash
hash(expr1, expr2, ...) - Returns a hash value of the arguments.
Examples:
> SELECT hash('Spark', array(123), 2);
-1321691492
hex
hex(expr) - Converts expr
to hexadecimal.
Examples:
> SELECT hex(17);
11
> SELECT hex('Spark SQL');
537061726B2053514C
hour
hour(timestamp) - Returns the hour component of the string/timestamp.
Examples:
> SELECT hour('2009-07-30 12:58:59');
12
Since: 1.5.0
hypot
hypot(expr1, expr2) - Returns sqrt(expr1
2 + expr2
2).
Examples:
> SELECT hypot(3, 4);
5.0
if
if(expr1, expr2, expr3) - If expr1
evaluates to true, then returns expr2
; otherwise returns expr3
.
Examples:
> SELECT if(1 < 2, 'a', 'b');
a
ifnull
ifnull(expr1, expr2) - Returns expr2
if expr1
is null, or expr1
otherwise.
Examples:
> SELECT ifnull(NULL, array('2'));
["2"]
Since: 2.0.0
in
expr1 in(expr2, expr3, ...) - Returns true if expr
equals to any valN.
Arguments:
- expr1, expr2, expr3, ... - the arguments must be same type.
Examples:
> SELECT 1 in(1, 2, 3);
true
> SELECT 1 in(2, 3, 4);
false
> SELECT named_struct('a', 1, 'b', 2) in(named_struct('a', 1, 'b', 1), named_struct('a', 1, 'b', 3));
false
> SELECT named_struct('a', 1, 'b', 2) in(named_struct('a', 1, 'b', 2), named_struct('a', 1, 'b', 3));
true
initcap
initcap(str) - Returns str
with the first letter of each word in uppercase.
All other letters are in lowercase. Words are delimited by white space.
Examples:
> SELECT initcap('sPark sql');
Spark Sql
Since: 1.5.0
inline
inline(expr) - Explodes an array of structs into a table.
Examples:
> SELECT inline(array(struct(1, 'a'), struct(2, 'b')));
1 a
2 b
inline_outer
inline_outer(expr) - Explodes an array of structs into a table.
Examples:
> SELECT inline_outer(array(struct(1, 'a'), struct(2, 'b')));
1 a
2 b
input_file_block_length
input_file_block_length() - Returns the length of the block being read, or -1 if not available.
input_file_block_start
input_file_block_start() - Returns the start offset of the block being read, or -1 if not available.
input_file_name
input_file_name() - Returns the name of the file being read, or empty string if not available.
instr
instr(str, substr) - Returns the (1-based) index of the first occurrence of substr
in str
.
Examples:
> SELECT instr('SparkSQL', 'SQL');
6
Since: 1.5.0
int
int(expr) - Casts the value expr
to the target data type int
.
isnan
isnan(expr) - Returns true if expr
is NaN, or false otherwise.
Examples:
> SELECT isnan(cast('NaN' as double));
true
Since: 1.5.0
isnotnull
isnotnull(expr) - Returns true if expr
is not null, or false otherwise.
Examples:
> SELECT isnotnull(1);
true
Since: 1.0.0
isnull
isnull(expr) - Returns true if expr
is null, or false otherwise.
Examples:
> SELECT isnull(1);
false
Since: 1.0.0
java_method
java_method(class, method[, arg1[, arg2 ..]]) - Calls a method with reflection.
Examples:
> SELECT java_method('java.util.UUID', 'randomUUID');
c33fb387-8500-4bfa-81d2-6e0e3e930df2
> SELECT java_method('java.util.UUID', 'fromString', 'a5cf6c42-0c85-418f-af6c-3e4e5b1328f2');
a5cf6c42-0c85-418f-af6c-3e4e5b1328f2
json_tuple
json_tuple(jsonStr, p1, p2, ..., pn) - Returns a tuple like the function get_json_object, but it takes multiple names. All the input parameters and output column types are string.
Examples:
> SELECT json_tuple('{"a":1, "b":2}', 'a', 'b');
1 2
kurtosis
kurtosis(expr) - Returns the kurtosis value calculated from values of a group.
lag
lag(input[, offset[, default]]) - Returns the value of input
at the offset
th row
before the current row in the window. The default value of offset
is 1 and the default
value of default
is null. If the value of input
at the offset
th row is null,
null is returned. If there is no such offset row (e.g., when the offset is 1, the first
row of the window does not have any previous row), default
is returned.
last
last(expr[, isIgnoreNull]) - Returns the last value of expr
for a group of rows.
If isIgnoreNull
is true, returns only non-null values.
last_day
last_day(date) - Returns the last day of the month which the date belongs to.
Examples:
> SELECT last_day('2009-01-12');
2009-01-31
Since: 1.5.0
last_value
last_value(expr[, isIgnoreNull]) - Returns the last value of expr
for a group of rows.
If isIgnoreNull
is true, returns only non-null values.
lcase
lcase(str) - Returns str
with all characters changed to lowercase.
Examples:
> SELECT lcase('SparkSql');
sparksql
Since: 1.0.1
lead
lead(input[, offset[, default]]) - Returns the value of input
at the offset
th row
after the current row in the window. The default value of offset
is 1 and the default
value of default
is null. If the value of input
at the offset
th row is null,
null is returned. If there is no such an offset row (e.g., when the offset is 1, the last
row of the window does not have any subsequent row), default
is returned.
least
least(expr, ...) - Returns the least value of all parameters, skipping null values.
Examples:
> SELECT least(10, 9, 2, 4, 3);
2
left
left(str, len) - Returns the leftmost len
(len
can be string type) characters from the string str
,if len
is less or equal than 0 the result is an empty string.
Examples:
> SELECT left('Spark SQL', 3);
Spa
Since: 2.3.0
length
length(expr) - Returns the character length of string data or number of bytes of binary data. The length of string data includes the trailing spaces. The length of binary data includes binary zeros.
Examples:
> SELECT length('Spark SQL ');
10
> SELECT CHAR_LENGTH('Spark SQL ');
10
> SELECT CHARACTER_LENGTH('Spark SQL ');
10
Since: 1.5.0
levenshtein
levenshtein(str1, str2) - Returns the Levenshtein distance between the two given strings.
Examples:
> SELECT levenshtein('kitten', 'sitting');
3
Since: 1.5.0
like
str like pattern - Returns true if str matches pattern, null if any arguments are null, false otherwise.
Arguments:
- str - a string expression
-
pattern - a string expression. The pattern is a string which is matched literally, with exception to the following special symbols:
_ matches any one character in the input (similar to . in posix regular expressions)
% matches zero or more characters in the input (similar to .* in posix regular expressions)
The escape character is '\'. If an escape character precedes a special symbol or another escape character, the following character is matched literally. It is invalid to escape any other character.
Since Spark 2.0, string literals are unescaped in our SQL parser. For example, in order to match "\abc", the pattern should be "\abc".
When SQL config 'spark.sql.parser.escapedStringLiterals' is enabled, it fallbacks to Spark 1.6 behavior regarding string literal parsing. For example, if the config is enabled, the pattern to match "\abc" should be "\abc".
Examples:
> SELECT '%SystemDrive%\Users\John' like '\%SystemDrive\%\\Users%'
true
Note:
Use RLIKE to match with standard regular expressions.
Since: 1.0.0
ln
ln(expr) - Returns the natural logarithm (base e) of expr
.
Examples:
> SELECT ln(1);
0.0
locate
locate(substr, str[, pos]) - Returns the position of the first occurrence of substr
in str
after position pos
.
The given pos
and return value are 1-based.
Examples:
> SELECT locate('bar', 'foobarbar');
4
> SELECT locate('bar', 'foobarbar', 5);
7
> SELECT POSITION('bar' IN 'foobarbar');
4
Since: 1.5.0
log
log(base, expr) - Returns the logarithm of expr
with base
.
Examples:
> SELECT log(10, 100);
2.0
log10
log10(expr) - Returns the logarithm of expr
with base 10.
Examples:
> SELECT log10(10);
1.0
log1p
log1p(expr) - Returns log(1 + expr
).
Examples:
> SELECT log1p(0);
0.0
log2
log2(expr) - Returns the logarithm of expr
with base 2.
Examples:
> SELECT log2(2);
1.0
lower
lower(str) - Returns str
with all characters changed to lowercase.
Examples:
> SELECT lower('SparkSql');
sparksql
Since: 1.0.1
lpad
lpad(str, len, pad) - Returns str
, left-padded with pad
to a length of len
.
If str
is longer than len
, the return value is shortened to len
characters.
Examples:
> SELECT lpad('hi', 5, '??');
???hi
> SELECT lpad('hi', 1, '??');
h
Since: 1.5.0
ltrim
ltrim(str) - Removes the leading space characters from str
.
ltrim(trimStr, str) - Removes the leading string contains the characters from the trim string
Arguments:
- str - a string expression
- trimStr - the trim string characters to trim, the default value is a single space
Examples:
> SELECT ltrim(' SparkSQL ');
SparkSQL
> SELECT ltrim('Sp', 'SSparkSQLS');
arkSQLS
Since: 1.5.0
map
map(key0, value0, key1, value1, ...) - Creates a map with the given key/value pairs.
Examples:
> SELECT map(1.0, '2', 3.0, '4');
{1.0:"2",3.0:"4"}
map_keys
map_keys(map) - Returns an unordered array containing the keys of the map.
Examples:
> SELECT map_keys(map(1, 'a', 2, 'b'));
[1,2]
map_values
map_values(map) - Returns an unordered array containing the values of the map.
Examples:
> SELECT map_values(map(1, 'a', 2, 'b'));
["a","b"]
max
max(expr) - Returns the maximum value of expr
.
md5
md5(expr) - Returns an MD5 128-bit checksum as a hex string of expr
.
Examples:
> SELECT md5('Spark');
8cde774d6f7333752ed72cacddb05126
mean
mean(expr) - Returns the mean calculated from values of a group.
min
min(expr) - Returns the minimum value of expr
.
minute
minute(timestamp) - Returns the minute component of the string/timestamp.
Examples:
> SELECT minute('2009-07-30 12:58:59');
58
Since: 1.5.0
mod
expr1 mod expr2 - Returns the remainder after expr1
/expr2
.
Examples:
> SELECT 2 mod 1.8;
0.2
> SELECT MOD(2, 1.8);
0.2
monotonically_increasing_id
monotonically_increasing_id() - Returns monotonically increasing 64-bit integers. The generated ID is guaranteed to be monotonically increasing and unique, but not consecutive. The current implementation puts the partition ID in the upper 31 bits, and the lower 33 bits represent the record number within each partition. The assumption is that the data frame has less than 1 billion partitions, and each partition has less than 8 billion records.
month
month(date) - Returns the month component of the date/timestamp.
Examples:
> SELECT month('2016-07-30');
7
Since: 1.5.0
months_between
months_between(timestamp1, timestamp2) - Returns number of months between timestamp1
and timestamp2
.
Examples:
> SELECT months_between('1997-02-28 10:30:00', '1996-10-30');
3.94959677
Since: 1.5.0
named_struct
named_struct(name1, val1, name2, val2, ...) - Creates a struct with the given field names and values.
Examples:
> SELECT named_struct("a", 1, "b", 2, "c", 3);
{"a":1,"b":2,"c":3}
nanvl
nanvl(expr1, expr2) - Returns expr1
if it's not NaN, or expr2
otherwise.
Examples:
> SELECT nanvl(cast('NaN' as double), 123);
123.0
Since: 1.5.0
negative
negative(expr) - Returns the negated value of expr
.
Examples:
> SELECT negative(1);
-1
next_day
next_day(start_date, day_of_week) - Returns the first date which is later than start_date
and named as indicated.
Examples:
> SELECT next_day('2015-01-14', 'TU');
2015-01-20
Since: 1.5.0
not
not expr - Logical not.
now
now() - Returns the current timestamp at the start of query evaluation.
Since: 1.5.0
ntile
ntile(n) - Divides the rows for each window partition into n
buckets ranging
from 1 to at most n
.
nullif
nullif(expr1, expr2) - Returns null if expr1
equals to expr2
, or expr1
otherwise.
Examples:
> SELECT nullif(2, 2);
NULL
Since: 2.0.0
nvl
nvl(expr1, expr2) - Returns expr2
if expr1
is null, or expr1
otherwise.
Examples:
> SELECT nvl(NULL, array('2'));
["2"]
Since: 2.0.0
nvl2
nvl2(expr1, expr2, expr3) - Returns expr2
if expr1
is not null, or expr3
otherwise.
Examples:
> SELECT nvl2(NULL, 2, 1);
1
Since: 2.0.0
octet_length
octet_length(expr) - Returns the byte length of string data or number of bytes of binary data.
Examples:
> SELECT octet_length('Spark SQL');
9
Since: 2.3.0
or
expr1 or expr2 - Logical OR.
parse_url
parse_url(url, partToExtract[, key]) - Extracts a part from a URL.
Examples:
> SELECT parse_url('http://spark.apache.org/path?query=1', 'HOST')
spark.apache.org
> SELECT parse_url('http://spark.apache.org/path?query=1', 'QUERY')
query=1
> SELECT parse_url('http://spark.apache.org/path?query=1', 'QUERY', 'query')
1
Since: 2.0.0
percent_rank
percent_rank() - Computes the percentage ranking of a value in a group of values.
percentile
percentile(col, percentage [, frequency]) - Returns the exact percentile value of numeric column
col
at the given percentage. The value of percentage must be between 0.0 and 1.0. The
value of frequency should be positive integral
percentile(col, array(percentage1 [, percentage2]...) [, frequency]) - Returns the exact
percentile value array of numeric column col
at the given percentage(s). Each value
of the percentage array must be between 0.0 and 1.0. The value of frequency should be
positive integral
percentile_approx
percentile_approx(col, percentage [, accuracy]) - Returns the approximate percentile value of numeric
column col
at the given percentage. The value of percentage must be between 0.0
and 1.0. The accuracy
parameter (default: 10000) is a positive numeric literal which
controls approximation accuracy at the cost of memory. Higher value of accuracy
yields
better accuracy, 1.0/accuracy
is the relative error of the approximation.
When percentage
is an array, each value of the percentage array must be between 0.0 and 1.0.
In this case, returns the approximate percentile array of column col
at the given
percentage array.
Examples:
> SELECT percentile_approx(10.0, array(0.5, 0.4, 0.1), 100);
[10.0,10.0,10.0]
> SELECT percentile_approx(10.0, 0.5, 100);
10.0
pi
pi() - Returns pi.
Examples:
> SELECT pi();
3.141592653589793
pmod
pmod(expr1, expr2) - Returns the positive value of expr1
mod expr2
.
Examples:
> SELECT pmod(10, 3);
1
> SELECT pmod(-10, 3);
2
posexplode
posexplode(expr) - Separates the elements of array expr
into multiple rows with positions, or the elements of map expr
into multiple rows and columns with positions.
Examples:
> SELECT posexplode(array(10,20));
0 10
1 20
posexplode_outer
posexplode_outer(expr) - Separates the elements of array expr
into multiple rows with positions, or the elements of map expr
into multiple rows and columns with positions.
Examples:
> SELECT posexplode_outer(array(10,20));
0 10
1 20
position
position(substr, str[, pos]) - Returns the position of the first occurrence of substr
in str
after position pos
.
The given pos
and return value are 1-based.
Examples:
> SELECT position('bar', 'foobarbar');
4
> SELECT position('bar', 'foobarbar', 5);
7
> SELECT POSITION('bar' IN 'foobarbar');
4
Since: 1.5.0
positive
positive(expr) - Returns the value of expr
.
pow
pow(expr1, expr2) - Raises expr1
to the power of expr2
.
Examples:
> SELECT pow(2, 3);
8.0
power
power(expr1, expr2) - Raises expr1
to the power of expr2
.
Examples:
> SELECT power(2, 3);
8.0
printf
printf(strfmt, obj, ...) - Returns a formatted string from printf-style format strings.
Examples:
> SELECT printf("Hello World %d %s", 100, "days");
Hello World 100 days
Since: 1.5.0
quarter
quarter(date) - Returns the quarter of the year for date, in the range 1 to 4.
Examples:
> SELECT quarter('2016-08-31');
3
Since: 1.5.0
radians
radians(expr) - Converts degrees to radians.
Arguments:
- expr - angle in degrees
Examples:
> SELECT radians(180);
3.141592653589793
rand
rand([seed]) - Returns a random value with independent and identically distributed (i.i.d.) uniformly distributed values in [0, 1).
Examples:
> SELECT rand();
0.9629742951434543
> SELECT rand(0);
0.8446490682263027
> SELECT rand(null);
0.8446490682263027
Since: 1.5.0
randn
randn([seed]) - Returns a random value with independent and identically distributed (i.i.d.) values drawn from the standard normal distribution.
Examples:
> SELECT randn();
-0.3254147983080288
> SELECT randn(0);
1.1164209726833079
> SELECT randn(null);
1.1164209726833079
Since: 1.5.0
rank
rank() - Computes the rank of a value in a group of values. The result is one plus the number of rows preceding or equal to the current row in the ordering of the partition. The values will produce gaps in the sequence.
reflect
reflect(class, method[, arg1[, arg2 ..]]) - Calls a method with reflection.
Examples:
> SELECT reflect('java.util.UUID', 'randomUUID');
c33fb387-8500-4bfa-81d2-6e0e3e930df2
> SELECT reflect('java.util.UUID', 'fromString', 'a5cf6c42-0c85-418f-af6c-3e4e5b1328f2');
a5cf6c42-0c85-418f-af6c-3e4e5b1328f2
regexp_extract
regexp_extract(str, regexp[, idx]) - Extracts a group that matches regexp
.
Examples:
> SELECT regexp_extract('100-200', '(\d+)-(\d+)', 1);
100
Since: 1.5.0
regexp_replace
regexp_replace(str, regexp, rep) - Replaces all substrings of str
that match regexp
with rep
.
Examples:
> SELECT regexp_replace('100-200', '(\d+)', 'num');
num-num
Since: 1.5.0
repeat
repeat(str, n) - Returns the string which repeats the given string value n times.
Examples:
> SELECT repeat('123', 2);
123123
Since: 1.5.0
replace
replace(str, search[, replace]) - Replaces all occurrences of search
with replace
.
Arguments:
- str - a string expression
- search - a string expression. If
search
is not found instr
,str
is returned unchanged. - replace - a string expression. If
replace
is not specified or is an empty string, nothing replaces the string that is removed fromstr
.
Examples:
> SELECT replace('ABCabc', 'abc', 'DEF');
ABCDEF
Since: 2.3.0
reverse
reverse(str) - Returns the reversed given string.
Examples:
> SELECT reverse('Spark SQL');
LQS krapS
right
right(str, len) - Returns the rightmost len
(len
can be string type) characters from the string str
,if len
is less or equal than 0 the result is an empty string.
Examples:
> SELECT right('Spark SQL', 3);
SQL
Since: 2.3.0
rint
rint(expr) - Returns the double value that is closest in value to the argument and is equal to a mathematical integer.
Examples:
> SELECT rint(12.3456);
12.0
rlike
str rlike regexp - Returns true if str
matches regexp
, or false otherwise.
Arguments:
- str - a string expression
-
regexp - a string expression. The pattern string should be a Java regular expression.
Since Spark 2.0, string literals (including regex patterns) are unescaped in our SQL parser. For example, to match "\abc", a regular expression for
regexp
can be "^\abc$".There is a SQL config 'spark.sql.parser.escapedStringLiterals' that can be used to fallback to the Spark 1.6 behavior regarding string literal parsing. For example, if the config is enabled, the
regexp
that can match "\abc" is "^\abc$".
Examples:
When spark.sql.parser.escapedStringLiterals is disabled (default).
> SELECT '%SystemDrive%\Users\John' rlike '%SystemDrive%\\Users.*'
true
When spark.sql.parser.escapedStringLiterals is enabled.
> SELECT '%SystemDrive%\Users\John' rlike '%SystemDrive%\Users.*'
true
Note:
Use LIKE to match with simple string pattern.
Since: 1.0.0
rollup
rollup([col1[, col2 ..]]) - create a multi-dimensional rollup using the specified columns so that we can run aggregation on them.
Examples:
> SELECT name, age, count(*) FROM VALUES (2, 'Alice'), (5, 'Bob') people(age, name) GROUP BY rollup(name, age);
NULL NULL 2
Alice 2 1
Bob 5 1
Bob NULL 1
Alice NULL 1
Since: 2.0.0
round
round(expr, d) - Returns expr
rounded to d
decimal places using HALF_UP rounding mode.
Examples:
> SELECT round(2.5, 0);
3.0
row_number
row_number() - Assigns a unique, sequential number to each row, starting with one, according to the ordering of rows within the window partition.
rpad
rpad(str, len, pad) - Returns str
, right-padded with pad
to a length of len
.
If str
is longer than len
, the return value is shortened to len
characters.
Examples:
> SELECT rpad('hi', 5, '??');
hi???
> SELECT rpad('hi', 1, '??');
h
Since: 1.5.0
rtrim
rtrim(str) - Removes the trailing space characters from str
.
rtrim(trimStr, str) - Removes the trailing string which contains the characters from the trim string from the str
Arguments:
- str - a string expression
- trimStr - the trim string characters to trim, the default value is a single space
Examples:
> SELECT rtrim(' SparkSQL ');
SparkSQL
> SELECT rtrim('LQSa', 'SSparkSQLS');
SSpark
Since: 1.5.0
second
second(timestamp) - Returns the second component of the string/timestamp.
Examples:
> SELECT second('2009-07-30 12:58:59');
59
Since: 1.5.0
sentences
sentences(str[, lang, country]) - Splits str
into an array of array of words.
Examples:
> SELECT sentences('Hi there! Good morning.');
[["Hi","there"],["Good","morning"]]
Since: 2.0.0
sha
sha(expr) - Returns a sha1 hash value as a hex string of the expr
.
Examples:
> SELECT sha('Spark');
85f5955f4b27a9a4c2aab6ffe5d7189fc298b92c
sha1
sha1(expr) - Returns a sha1 hash value as a hex string of the expr
.
Examples:
> SELECT sha1('Spark');
85f5955f4b27a9a4c2aab6ffe5d7189fc298b92c
sha2
sha2(expr, bitLength) - Returns a checksum of SHA-2 family as a hex string of expr
.
SHA-224, SHA-256, SHA-384, and SHA-512 are supported. Bit length of 0 is equivalent to 256.
Examples:
> SELECT sha2('Spark', 256);
529bc3b07127ecb7e53a4dcf1991d9152c24537d919178022b2c42657f79a26b
shiftleft
shiftleft(base, expr) - Bitwise left shift.
Examples:
> SELECT shiftleft(2, 1);
4
shiftright
shiftright(base, expr) - Bitwise (signed) right shift.
Examples:
> SELECT shiftright(4, 1);
2
shiftrightunsigned
shiftrightunsigned(base, expr) - Bitwise unsigned right shift.
Examples:
> SELECT shiftrightunsigned(4, 1);
2
sign
sign(expr) - Returns -1.0, 0.0 or 1.0 as expr
is negative, 0 or positive.
Examples:
> SELECT sign(40);
1.0
signum
signum(expr) - Returns -1.0, 0.0 or 1.0 as expr
is negative, 0 or positive.
Examples:
> SELECT signum(40);
1.0
sin
sin(expr) - Returns the sine of expr
, as if computed by java.lang.Math.sin
.
Arguments:
- expr - angle in radians
Examples:
> SELECT sin(0);
0.0
sinh
sinh(expr) - Returns hyperbolic sine of expr
, as if computed by java.lang.Math.sinh
.
Arguments:
- expr - hyperbolic angle
Examples:
> SELECT sinh(0);
0.0
size
size(expr) - Returns the size of an array or a map. Returns -1 if null.
Examples:
> SELECT size(array('b', 'd', 'c', 'a'));
4
skewness
skewness(expr) - Returns the skewness value calculated from values of a group.
smallint
smallint(expr) - Casts the value expr
to the target data type smallint
.
sort_array
sort_array(array[, ascendingOrder]) - Sorts the input array in ascending or descending order according to the natural ordering of the array elements.
Examples:
> SELECT sort_array(array('b', 'd', 'c', 'a'), true);
["a","b","c","d"]
soundex
soundex(str) - Returns Soundex code of the string.
Examples:
> SELECT soundex('Miller');
M460
Since: 1.5.0
space
space(n) - Returns a string consisting of n
spaces.
Examples:
> SELECT concat(space(2), '1');
1
Since: 1.5.0
spark_partition_id
spark_partition_id() - Returns the current partition id.
split
split(str, regex) - Splits str
around occurrences that match regex
.
Examples:
> SELECT split('oneAtwoBthreeC', '[ABC]');
["one","two","three",""]
Since: 1.5.0
sqrt
sqrt(expr) - Returns the square root of expr
.
Examples:
> SELECT sqrt(4);
2.0
stack
stack(n, expr1, ..., exprk) - Separates expr1
, ..., exprk
into n
rows.
Examples:
> SELECT stack(2, 1, 2, 3);
1 2
3 NULL
std
std(expr) - Returns the sample standard deviation calculated from values of a group.
stddev
stddev(expr) - Returns the sample standard deviation calculated from values of a group.
stddev_pop
stddev_pop(expr) - Returns the population standard deviation calculated from values of a group.
stddev_samp
stddev_samp(expr) - Returns the sample standard deviation calculated from values of a group.
str_to_map
str_to_map(text[, pairDelim[, keyValueDelim]]) - Creates a map after splitting the text into key/value pairs using delimiters. Default delimiters are ',' for pairDelim
and ':' for keyValueDelim
.
Examples:
> SELECT str_to_map('a:1,b:2,c:3', ',', ':');
map("a":"1","b":"2","c":"3")
> SELECT str_to_map('a');
map("a":null)
string
string(expr) - Casts the value expr
to the target data type string
.
struct
struct(col1, col2, col3, ...) - Creates a struct with the given field values.
substr
substr(str, pos[, len]) - Returns the substring of str
that starts at pos
and is of length len
, or the slice of byte array that starts at pos
and is of length len
.
Examples:
> SELECT substr('Spark SQL', 5);
k SQL
> SELECT substr('Spark SQL', -3);
SQL
> SELECT substr('Spark SQL', 5, 1);
k
Since: 1.5.0
substring
substring(str, pos[, len]) - Returns the substring of str
that starts at pos
and is of length len
, or the slice of byte array that starts at pos
and is of length len
.
Examples:
> SELECT substring('Spark SQL', 5);
k SQL
> SELECT substring('Spark SQL', -3);
SQL
> SELECT substring('Spark SQL', 5, 1);
k
Since: 1.5.0
substring_index
substring_index(str, delim, count) - Returns the substring from str
before count
occurrences of the delimiter delim
.
If count
is positive, everything to the left of the final delimiter (counting from the
left) is returned. If count
is negative, everything to the right of the final delimiter
(counting from the right) is returned. The function substring_index performs a case-sensitive match
when searching for delim
.
Examples:
> SELECT substring_index('www.apache.org', '.', 2);
www.apache
Since: 1.5.0
sum
sum(expr) - Returns the sum calculated from values of a group.
tan
tan(expr) - Returns the tangent of expr
, as if computed by java.lang.Math.tan
.
Arguments:
- expr - angle in radians
Examples:
> SELECT tan(0);
0.0
tanh
tanh(expr) - Returns the hyperbolic tangent of expr
, as if computed by
java.lang.Math.tanh
.
Arguments:
- expr - hyperbolic angle
Examples:
> SELECT tanh(0);
0.0
timestamp
timestamp(expr) - Casts the value expr
to the target data type timestamp
.
tinyint
tinyint(expr) - Casts the value expr
to the target data type tinyint
.
to_date
to_date(date_str[, fmt]) - Parses the date_str
expression with the fmt
expression to
a date. Returns null with invalid input. By default, it follows casting rules to a date if
the fmt
is omitted.
Examples:
> SELECT to_date('2009-07-30 04:17:52');
2009-07-30
> SELECT to_date('2016-12-31', 'yyyy-MM-dd');
2016-12-31
Since: 1.5.0
to_json
to_json(expr[, options]) - Returns a json string with a given struct value
Examples:
> SELECT to_json(named_struct('a', 1, 'b', 2));
{"a":1,"b":2}
> SELECT to_json(named_struct('time', to_timestamp('2015-08-26', 'yyyy-MM-dd')), map('timestampFormat', 'dd/MM/yyyy'));
{"time":"26/08/2015"}
> SELECT to_json(array(named_struct('a', 1, 'b', 2)));
[{"a":1,"b":2}]
> SELECT to_json(map('a', named_struct('b', 1)));
{"a":{"b":1}}
> SELECT to_json(map(named_struct('a', 1),named_struct('b', 2)));
{"[1]":{"b":2}}
> SELECT to_json(map('a', 1));
{"a":1}
> SELECT to_json(array((map('a', 1))));
[{"a":1}]
Since: 2.2.0
to_timestamp
to_timestamp(timestamp[, fmt]) - Parses the timestamp
expression with the fmt
expression to
a timestamp. Returns null with invalid input. By default, it follows casting rules to
a timestamp if the fmt
is omitted.
Examples:
> SELECT to_timestamp('2016-12-31 00:12:00');
2016-12-31 00:12:00
> SELECT to_timestamp('2016-12-31', 'yyyy-MM-dd');
2016-12-31 00:00:00
Since: 2.2.0
to_unix_timestamp
to_unix_timestamp(expr[, pattern]) - Returns the UNIX timestamp of the given time.
Examples:
> SELECT to_unix_timestamp('2016-04-08', 'yyyy-MM-dd');
1460041200
Since: 1.6.0
to_utc_timestamp
to_utc_timestamp(timestamp, timezone) - Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in the given time zone, and renders that time as a timestamp in UTC. For example, 'GMT+1' would yield '2017-07-14 01:40:00.0'.
Examples:
> SELECT to_utc_timestamp('2016-08-31', 'Asia/Seoul');
2016-08-30 15:00:00
Since: 1.5.0
translate
translate(input, from, to) - Translates the input
string by replacing the characters present in the from
string with the corresponding characters in the to
string.
Examples:
> SELECT translate('AaBbCc', 'abc', '123');
A1B2C3
Since: 1.5.0
trim
trim(str) - Removes the leading and trailing space characters from str
.
trim(BOTH trimStr FROM str) - Remove the leading and trailing trimStr
characters from str
trim(LEADING trimStr FROM str) - Remove the leading trimStr
characters from str
trim(TRAILING trimStr FROM str) - Remove the trailing trimStr
characters from str
Arguments:
- str - a string expression
- trimStr - the trim string characters to trim, the default value is a single space
- BOTH, FROM - these are keywords to specify trimming string characters from both ends of the string
- LEADING, FROM - these are keywords to specify trimming string characters from the left end of the string
- TRAILING, FROM - these are keywords to specify trimming string characters from the right end of the string
Examples:
> SELECT trim(' SparkSQL ');
SparkSQL
> SELECT trim('SL', 'SSparkSQLS');
parkSQ
> SELECT trim(BOTH 'SL' FROM 'SSparkSQLS');
parkSQ
> SELECT trim(LEADING 'SL' FROM 'SSparkSQLS');
parkSQLS
> SELECT trim(TRAILING 'SL' FROM 'SSparkSQLS');
SSparkSQ
Since: 1.5.0
trunc
trunc(date, fmt) - Returns date
with the time portion of the day truncated to the unit specified by the format model fmt
.
fmt
should be one of ["year", "yyyy", "yy", "mon", "month", "mm"]
Examples:
> SELECT trunc('2009-02-12', 'MM');
2009-02-01
> SELECT trunc('2015-10-27', 'YEAR');
2015-01-01
Since: 1.5.0
ucase
ucase(str) - Returns str
with all characters changed to uppercase.
Examples:
> SELECT ucase('SparkSql');
SPARKSQL
Since: 1.0.1
unbase64
unbase64(str) - Converts the argument from a base 64 string str
to a binary.
Examples:
> SELECT unbase64('U3BhcmsgU1FM');
Spark SQL
Since: 1.5.0
unhex
unhex(expr) - Converts hexadecimal expr
to binary.
Examples:
> SELECT decode(unhex('537061726B2053514C'), 'UTF-8');
Spark SQL
unix_timestamp
unix_timestamp([expr[, pattern]]) - Returns the UNIX timestamp of current or specified time.
Examples:
> SELECT unix_timestamp();
1476884637
> SELECT unix_timestamp('2016-04-08', 'yyyy-MM-dd');
1460041200
Since: 1.5.0
upper
upper(str) - Returns str
with all characters changed to uppercase.
Examples:
> SELECT upper('SparkSql');
SPARKSQL
Since: 1.0.1
uuid
uuid() - Returns an universally unique identifier (UUID) string. The value is returned as a canonical UUID 36-character string.
Examples:
> SELECT uuid();
46707d92-02f4-4817-8116-a4c3b23e6266
var_pop
var_pop(expr) - Returns the population variance calculated from values of a group.
var_samp
var_samp(expr) - Returns the sample variance calculated from values of a group.
variance
variance(expr) - Returns the sample variance calculated from values of a group.
weekofyear
weekofyear(date) - Returns the week of the year of the given date. A week is considered to start on a Monday and week 1 is the first week with >3 days.
Examples:
> SELECT weekofyear('2008-02-20');
8
Since: 1.5.0
when
CASE WHEN expr1 THEN expr2 [WHEN expr3 THEN expr4]* [ELSE expr5] END - When expr1
= true, returns expr2
; else when expr3
= true, returns expr4
; else returns expr5
.
Arguments:
- expr1, expr3 - the branch condition expressions should all be boolean type.
- expr2, expr4, expr5 - the branch value expressions and else value expression should all be same type or coercible to a common type.
Examples:
> SELECT CASE WHEN 1 > 0 THEN 1 WHEN 2 > 0 THEN 2.0 ELSE 1.2 END;
1
> SELECT CASE WHEN 1 < 0 THEN 1 WHEN 2 > 0 THEN 2.0 ELSE 1.2 END;
2
> SELECT CASE WHEN 1 < 0 THEN 1 WHEN 2 < 0 THEN 2.0 END;
NULL
window
xpath
xpath(xml, xpath) - Returns a string array of values within the nodes of xml that match the XPath expression.
Examples:
> SELECT xpath('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>','a/b/text()');
['b1','b2','b3']
xpath_boolean
xpath_boolean(xml, xpath) - Returns true if the XPath expression evaluates to true, or if a matching node is found.
Examples:
> SELECT xpath_boolean('<a><b>1</b></a>','a/b');
true
xpath_double
xpath_double(xml, xpath) - Returns a double value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Examples:
> SELECT xpath_double('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3.0
xpath_float
xpath_float(xml, xpath) - Returns a float value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Examples:
> SELECT xpath_float('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3.0
xpath_int
xpath_int(xml, xpath) - Returns an integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Examples:
> SELECT xpath_int('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3
xpath_long
xpath_long(xml, xpath) - Returns a long integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Examples:
> SELECT xpath_long('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3
xpath_number
xpath_number(xml, xpath) - Returns a double value, the value zero if no match is found, or NaN if a match is found but the value is non-numeric.
Examples:
> SELECT xpath_number('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3.0
xpath_short
xpath_short(xml, xpath) - Returns a short integer value, or the value zero if no match is found, or a match is found but the value is non-numeric.
Examples:
> SELECT xpath_short('<a><b>1</b><b>2</b></a>', 'sum(a/b)');
3
xpath_string
xpath_string(xml, xpath) - Returns the text contents of the first xml node that matches the XPath expression.
Examples:
> SELECT xpath_string('<a><b>b</b><c>cc</c></a>','a/c');
cc
year
year(date) - Returns the year component of the date/timestamp.
Examples:
> SELECT year('2016-07-30');
2016
Since: 1.5.0
|
expr1 | expr2 - Returns the result of bitwise OR of expr1
and expr2
.
Examples:
> SELECT 3 | 5;
7
~
~ expr - Returns the result of bitwise NOT of expr
.
Examples:
> SELECT ~ 0;
-1


The total abjad value of … is …
The 28 primary letters, in “Eastern” abjad order (right to left, row by row):
Arabic secondary letters:
Persian-specific letters:
© 2017–22
T. S. Beers
The source files for this page are available
on GitHub
under the
MIT License.
I’m not much of a developer. If anything is messed up, please
let me know by email!


Note 1 : Recommended statistics for this type of classification highlighted in aqua
Note 2 : The recommender system assumes that the input is the result of classification over the whole data rather than just a part of it. If the confusion matrix is the result of test data classification, the recommendation is not valid.
| Actual | Predict
|
| Class | Barrett's_Esophagus | Esophageal_Adenocarcinoma | Normal | Reflux_Esophagitis | Description |
| ACC | 0.79464 | 0.84226 | 0.92262 | 0.89286 | Accuracy |
| AGF | 0.62931 | 0.76823 | 0.93047 | 0.89543 | Adjusted F-score |
| AGM | 0.75347 | 0.82757 | 0.9229 | 0.89227 | Adjusted geometric mean |
| AM | -25 | -5 | 14 | 16 | Difference between automatic and manual classification |
| AUC | 0.67659 | 0.77976 | 0.9246 | 0.88889 | Area under the ROC curve |
| AUCI | Fair | Good | Excellent | Very Good | AUC value interpretation |
| AUPR | 0.5338 | 0.67548 | 0.86224 | 0.81048 | Area under the PR curve |
| BCD | 0.0372 | 0.00744 | 0.02083 | 0.02381 | Bray-Curtis dissimilarity |
| BM | 0.35317 | 0.55952 | 0.84921 | 0.77778 | Informedness or bookmaker informedness |
| CEN | 0.62937 | 0.47737 | 0.28114 | 0.33248 | Confusion entropy |
| DOR | 8.23017 | 18.01724 | 150.8 | 64.32308 | Diagnostic odds ratio |
| DP | 0.50469 | 0.6923 | 1.20102 | 0.997 | Discriminant power |
| DPI | Poor | Poor | Limited | Poor | Discriminant power interpretation |
| ERR | 0.20536 | 0.15774 | 0.07738 | 0.10714 | Error rate |
| F0.5 | 0.57812 | 0.6875 | 0.81933 | 0.76446 | F0.5 score |
| F1 | 0.51748 | 0.67485 | 0.85714 | 0.80435 | F1 score - harmonic mean of precision and sensitivity |
| F2 | 0.46835 | 0.66265 | 0.89862 | 0.84862 | F2 score |
| FDR | 0.37288 | 0.3038 | 0.20408 | 0.26 | False discovery rate |
| FN | 47 | 29 | 6 | 10 | False negative/miss/type 2 error |
| FNR | 0.55952 | 0.34524 | 0.07143 | 0.11905 | Miss rate or false negative rate |
| FOR | 0.16968 | 0.11284 | 0.02521 | 0.04237 | False omission rate |
| FP | 22 | 24 | 20 | 26 | False positive/type 1 error/false alarm |
| FPR | 0.0873 | 0.09524 | 0.07937 | 0.10317 | Fall-out or false positive rate |
| G | 0.52558 | 0.67516 | 0.85969 | 0.80741 | G-measure geometric mean of precision and sensitivity |
| GI | 0.35317 | 0.55952 | 0.84921 | 0.77778 | Gini index |
| GM | 0.63405 | 0.76968 | 0.92459 | 0.88885 | G-mean geometric mean of specificity and sensitivity |
| IBA | 0.21218 | 0.4443 | 0.86166 | 0.77752 | Index of balanced accuracy |
| IS | 1.32681 | 1.47758 | 1.67069 | 1.5656 | Information score |
| J | 0.34906 | 0.50926 | 0.75 | 0.67273 | Jaccard index |
| LS | 2.50847 | 2.78481 | 3.18367 | 2.96 | Lift score |
| MCC | 0.40194 | 0.57132 | 0.80901 | 0.73661 | Matthews correlation coefficient |
| MCCI | Weak | Moderate | Strong | Strong | Matthews correlation coefficient interpretation |
| MCEN | 0.74028 | 0.60773 | 0.41392 | 0.46218 | Modified confusion entropy |
| MK | 0.45744 | 0.58336 | 0.77071 | 0.69763 | Markedness |
| N | 252 | 252 | 252 | 252 | Condition negative |
| NLR | 0.61304 | 0.38158 | 0.07759 | 0.13274 | Negative likelihood ratio |
| NLRI | Negligible | Poor | Good | Fair | Negative likelihood ratio interpretation |
| NPV | 0.83032 | 0.88716 | 0.97479 | 0.95763 | Negative predictive value |
| OC | 0.62712 | 0.6962 | 0.92857 | 0.88095 | Overlap coefficient |
| OOC | 0.52558 | 0.67516 | 0.85969 | 0.80741 | Otsuka-Ochiai coefficient |
| OP | 0.44567 | 0.68196 | 0.91833 | 0.88393 | Optimized precision |
| P | 84 | 84 | 84 | 84 | Condition positive or support |
| PLR | 5.04545 | 6.875 | 11.7 | 8.53846 | Positive likelihood ratio |
| PLRI | Fair | Fair | Good | Fair | Positive likelihood ratio interpretation |
| POP | 336 | 336 | 336 | 336 | Population |
| PPV | 0.62712 | 0.6962 | 0.79592 | 0.74 | Precision or positive predictive value |
| PRE | 0.25 | 0.25 | 0.25 | 0.25 | Prevalence |
| Q | 0.78332 | 0.89483 | 0.98682 | 0.96938 | Yule Q - coefficient of colligation |
| RACC | 0.0439 | 0.05878 | 0.07292 | 0.0744 | Random accuracy |
| RACCU | 0.04528 | 0.05884 | 0.07335 | 0.07497 | Random accuracy unbiased |
| TN | 230 | 228 | 232 | 226 | True negative/correct rejection |
| TNR | 0.9127 | 0.90476 | 0.92063 | 0.89683 | Specificity or true negative rate |
| TON | 277 | 257 | 238 | 236 | Test outcome negative |
| TOP | 59 | 79 | 98 | 100 | Test outcome positive |
| TP | 37 | 55 | 78 | 74 | True positive/hit |
| TPR | 0.44048 | 0.65476 | 0.92857 | 0.88095 | Sensitivity, recall, hit rate, or true positive rate |
| Y | 0.35317 | 0.55952 | 0.84921 | 0.77778 | Youden index |
| dInd | 0.56629 | 0.35813 | 0.10677 | 0.15754 | Distance index |
| sInd | 0.59957 | 0.74676 | 0.9245 | 0.88861 | Similarity index |
Generated By PyCM Version 2.4


{title:'REST Client', created:'9.0.0'}
Built upon the feature-rich Apache HttpClient library, the Juneau RestClient API adds support for fluent-style REST calls and the ability to perform marshalling of POJOs to and from HTTP parts.
|
The {@link oajr.mock.MockRestClient} class is used for performing serverless unit testing of {@link oajr.annotation.Rest @Rest}-annotated and {@link oaj.http.remote.Remote @Remote}-annotated classes. It perform full serialization and parsing of the HTTP request and responses, but bypasses the network layer to significantly improve speed while still performing real testing.
|


Chapter 4. The Python Language
This
chapter is a quick guide to the Python language. To learn Python from
scratch, I suggest you start with Learning
Python, by Mark Lutz and David Ascher
(O'Reilly). If you already know other programming
languages and just want to learn the specifics of Python, this
chapter is for you. I'm not trying to teach Python
here, so we're going to cover a lot of ground at a
pretty fast pace.
|