Sugar-phosphate phosphohydrolase that appears to contribute to butanol tolerance (PubMed:27941785). Catalyzes the dephosphorylation of D-mannitol 1-phosphate and D-sorbitol 6-phosphate (PubMed:27941785). Is also able to dephosphorylate other sugar phosphates in vitro including ribose-5-phosphate (Rib5P), 2-deoxyribose-5-phosphate, fructose-1-phosphate (Fru1P), fructose-6-phosphate (Fru6P), and glucose-6-phosphate (Glu6P) (PubMed:16990279). Selectively hydrolyzes beta-D-glucose-1-phosphate (bGlu1P) and has no activity with the alpha form (PubMed:16990279). sugar phosphate + H2O = sugar + phosphate. D-mannitol 1-phosphate + H2O = D-mannitol + phosphate D-sorbitol 6-phosphate + H2O = D-sorbitol + phosphate Requires the presence of a divalent metal cation for activity. Can use magnesium, manganese or cobalt. kcat is 3.7 sec(-1) with fructose-1-P as substrate. kcat is 2.7 sec(-1) with ribose-5-P as substrate. kcat is 13 sec(-1) with glucose-6-P as substrate. kcat is 3.1 sec(-1) with fructose-6-P as substrate. kcat is 7.5 sec(-1) with beta-D-glucose-1-P as substrate. Optimum pH is between 6 and 7.5. Cells lacking this gene show a reduced growth rate at high butanol concentrations compared to wild-type. They also show a consistent change in the level of mannitol, D-sorbitol, galactitol, L-tyrosine, 3-amino-3-(4-hydroxyphenyl)propanoate and N-hydroxy-L-phenylalanine. Belongs to the HAD-like hydrolase superfamily. CbbY/CbbZ/Gph/YieH family.